This topic describes how to configure a DB2 UDB JDBC provider and
data source for the business process container.
- On UNIX and Linux platforms, perform Configuring a DB2 database on a Linux, UNIX, or Windows system. On Windows the environment is set up automatically.
- Change to the Business Process Choreographer directory: On Windows, enter:
cd install_root\ProcessChoreographer
On
UNIX and Linux platforms, enter: cd install_root/ProcessChoreographer
- Run the configuration script. This script creates a data source
that uses the DB2 Legacy CLI-based type-2 JDBC driver (XA). On
Windows platforms, enter:
install_root\bin\wsadmin -f create_ds_Db2.jacl
[-node <nodeName>] -server <serverName> -dbPath <databasePath>
[-dbName <databaseName>] -userid <userID> -passwd <password>
On
UNIX and Linux platforms, enter:install_root/bin/wsadmin.sh -f create_ds_Db2.jacl
[-node <nodeName>] -server <serverName> -dbPath <databasePath>
[-dbName <databaseName>] -userid <userID> -passwd <password>
Where: - wsadmin
- is located in the bin subdirectory of the IBM WebSphere Application
Server installation directory.
- create_ds_Db2.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 the optional node name.
- serverName
- is the application server name.
- dbPath
- is the location where your DB2 system is installed. Note: On Windows you
must use forward slashes (/) instead of back slashes (\) to specify the path,
for example, "c:/sqllib".
- databaseName
- is the optional database name. If you do not provide a name the default BPEDB will
be used.
- 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 DB2 JDBC provider and data source have been configured for the
business process container.
Configure the queue resources.