Setting the WebSphere variables for Db2 data sources

Ensure that the following WebSphere® variables are set correctly:
DB2UNIVERSAL_JDBC_DRIVER_PATH
Set this variable to the directory in which the Db2® JDBC driver library file (db2jcc4.jar) is located, for example: 
/opt/ibm/db2/V11.1/java
UNIVERSAL_JDBC_DRIVER_PATH
Set this variable to the directory in which the license file required to connect to used Db2 version (db2jcc_license_cu.jar) is located, for example: 
/usr/IBM/WebSphere/AppServer/universalDriver/lib

To change the settings of these variables:

  1. Log on to the administrative console as the WebSphere Application Server administrator. The recommended user ID of this user is uwasa1. The access rights of this user are described in Table 1.
  2. Click Environment > WebSphere Variables.
  3. Set scope to All scopes
  4. Change the variable settings as needed. You can define each of these variables at a different scope in a WebSphere Application Server environment.