Configure a JDBC provider for a clustered environment
Use these steps to define a data source on multiple nodes that comprise a cluster.
See the topic, Administrative console scope settings, for more information about scope settings in general.
The cluster scope has precedence over the node and cell scopes. Create a JDBC provider for a cluster if we want the associated data source to:
- Be available for all the members of this cluster to use
- Override any resource factories that have the same JNDI name defined within the cell scope
- Open the administrative console.
- Click Resources > JDBC > JDBC Providers.
- From the scope drop-down list, select the cluster for which you are creating the JDBC provider. (This scope becomes the scope of any data source that you associate with this provider.)
- Click New. This action causes the Create a new JDBC Provider wizard to launch.
- Complete the wizard, then click Finish. For details on using this wizard, see the topic, Configuring a JDBC provider using the administrative console.
- Click Environment > WebSphere Variables in the administrative console.
- For each node in the cluster, select the symbolic variable used in the class path of the JDBC provider, and provide a value that is appropriate for the selected node. For example, if the class path 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 the 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.
This variable must be defined on each node within the cluster.
What to do next
We are now ready to configure the data source. For guidance, refer to the topic, Configuring a data source using the administrative console.
Related tasks
Configure a JDBC provider using the administrative console Configure a data source using the administrative console
Administrative console scope settings