Use these steps to define a data source on multiple nodes that
comprise a cluster.
About this task
The cluster scope has precedence over the node and cell scopes. Create
a JDBC provider for a cluster if you 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 that is defined
within the cell scope
Procedure
- 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 article 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 your 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 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 within the cluster.