Use these steps to define
a data source on multiple nodes that
comprise a cluster.
Before you begin
See the topic, Administrative
console scope settings,
for more information about scope settings in general.
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 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 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.
What to do next
You are now ready to configure your data source.
For guidance, refer
to the topic, Configuring a data source using the administrative console.