Create a JDBC provider on multiple nodes

 

Overview

These are the instructions to create a JDBC provider in a Network Development (ND) environment. This sample configuration involves two base nodes: node A and node B added to ND on node C.

  1. Open the administrative console.

  2. Click Resources > JDBC Providers. The default listing is at the node level.

  3. Leave the node text field blank and click Apply to change the scope to the cell level.

  4. Click New to create a new JDBC provider at the cell level. The classpath for your new JDBC provider will already be filled in, and part of that classpath will be specified using a symbolic variable, for example ${DB2390_JDBC_DRIVER_PATH}/classes/db2j2classes.zip . Leave it at the default.

  5. Finish creating the JDBC provider.

  6. Click Environment.

  7. Click Manage WebSphere Variables.

  8. For each node, select the symbolic variable used in the classpath of your JDBC provider, and provide a value that is appropriate for the selected node.For example, if the classpath of your JDBC provider uses the symbolic variable ${DB2390_JDBC_DRIVER_PATH}, you might supply the value /usr/lpp/db2 on one node and /usr/lpp/db2710 on another node, depending on where your DB2 390 installation is located.

  9. Click DB2_JDBC_DRIVER_PATH (this already exists by default). Here provide the path (in the value field) where db2java.zip exists on the selected node.

  10. Click Apply and save the changes.

    Note: This variable must be defined on each node under the cell.