What are the prerequisites or changes required at WAS level(Application server) when AUTHENTICATION is changed to DATA_ENCRYPT in DB2 server?
Priyanka Joshi 270003HTNX Visits (2900)
On DB2 server, we have a database manager configuration parameter - AUTHENTICATION, which specifies and determines how and where authentication of a user takes place. There are different options you could select based on your requirement.
Reference : http
A value of DATA_ENCRYPT means the authentication takes place at the server and it expects the user IDs, passwords and data that is sent over the network to be encrypted.
In almost all cases, WAS uses JDBC/JCC type 4 connection type to connect to db2 server.
So, please set the “securityMechanism" property to ENCR
Please review the following link for more details :
Important : After you make the above changes to database and client authentication settings, you must stop and restart the Websphere Application Server in order for it to pick up the change.