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
- 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.
- 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.
- Log in to the WebSphere Integrated
Solutions Console and the WebSphere administrator
(the ID you created when you installed WebSphere Application Server).
- Click .
- 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.
- Click the Save link in the "Messages"
box at the beginning of the page.
- Repeat steps 5 and 6 for all instances of the driver.
- Synchronize the nodes in the cluster:
- Click .
- Select both nodes, and then click Full Resynchronization.