Configuring a connection to the JDBC provider

To create a connection to the Bandwidth Manager database hosted on the IBM® DB2® server, you must configure IBM WebSphere® Application Server to use the driver implementation classes that are encapsulated by the Java™ Database Connectivity (JDBC) provider.

About this task

Configuring the JDBC provider involves using the WebSphere Integrated Solutions Console to define a path to the location where the JDBC drivers reside.

Procedure

  1. On the deployment manager, open the folder WAS_Install_Root/deploytool/itp/plugins.

    WAS_install_root is the root directory where WebSphere Application Server is installed. In Microsoft® Windows® this is typically C:\Program Files\WebSphere\AppServer and in Linux® it is typically /opt/IBM/WebSphere/AppServer.

  2. Now locate the subfolder named com.ibm.datatools.db2_2.0.101.vXXXXXXXXXXXX, where "XXXXXXXXXXXX" is a 12-digit number.

    This is the path to the JDBC drivers; you will need this information later in step 5. Be sure to place it in a location from which you can copy and past it later.

  3. Log in to the WebSphere Integrated Solutions Console and the WebSphere administrator (the ID you created when you installed WebSphere Application Server).
  4. Click Environment > WebSphere variables.
  5. Click on the environment variable DB2UNIVERSAL_JDBC_DRIVER_PATH. In the Value field enter the complete path to the drivers you located in step 2. Click OK.

    For example, the path will be WAS_install_root/deploytool/itp/plugins/com.ibm.datatools.db2_2.0.101.vXXXXXXXXXXXX, where "XXXXXXXXXXXX" is a 12-digit number.

  6. Click the Save link in the "Messages" box at the beginning of the page.
  7. Repeat steps 5 and 6 for all instances of the driver.
  8. Synchronize the nodes in the cluster:
    1. Click System Administration > Nodes.
    2. Select both nodes, and then click Full Resynchronization.