This topic describes how to configure a DB2 UDB for iSeries JDBC
provider and data source for the business process container.
- On UNIX, perform Configure
WebSphere Application Server for DB2 access. On
Windows the environment is set up automatically.
- Change to the Business Process Choreographer directory. On
Windows, enter:
cd install_root\ProcessChoreographer
On
UNIX, enter:cd install_root/ProcessChoreographer
- Run the configuration script to create a data source that uses
the DB2 UDB for iSeries Toolbox XA driver. On Windows, enter:
install_root\bin\wsadmin -f create_ds_Db2iSeries.jacl
[-node <nodeName>] -server <serverName>
-jdbcDriverPath <driver path to toolbox driver>
-dbServer <db server name>] -userid <userID> -password <password>
On
UNIX, enter:install_root/bin/wsadmin.sh -f create_ds_Db2iSeries.jacl
[-node <nodeName>] -server <serverName>
-jdbcDriverPath <driver path to toolbox driver>
-dbServer <db server name> -userid <userID> -password <password>
Where:- wsadmin
- is located in the bin subdirectory of the IBM WebSphere
Application Server installation directory.
- create_ds_Db2iSeries.jacl
- is the script file that performs the configuration within WebSphere. It
is located in the ProcessChoreographer subdirectory of the
IBM WebSphere Application Server installation directory. For example, on a
default Windows installation, it is in the directory c:\Program Files\WebSphere\AppServer\ProcessChoreographer.
- nodeName
- is an optional node name.
- serverName
- is the application server name.
- driver path to toolbox driver
- is the location where the Toolbox driver is installed on your Application
Server machine. If necessary, you can download the JAR file for the driver
from /QIBM/ProdData/Http/Public/jt400/lib/jt400.jar.
- db server name
- is the name of your iSeries system.
- userID
- is the user ID for accessing the database. This must be the same user
ID that was used to create the database and the schema.
- password
- is the password for userID.
- If you had problems using the script, you can perform Using the administrative console to configure the JDBC provider
and data source.
The data source BPEDataSourceDb2iSeries has been
created and is now listed in the data source panel.