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.
- Open the administrative console.
- Click Resources > JDBC Providers. The default listing is at the node level.
- Leave the node text field blank and click Apply to change the scope to the cell level.
- 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.
- Finish creating the JDBC provider.
- Click Environment.
- Click Manage WebSphere Variables.
- 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.
- 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.
- Click Apply and save the changes.
Note: This variable must be defined on each node under the cell.