Configuring a DB2 UDB for Linux, UNIX, and Windows JDBC provider and data source for the business process container

This topic describes how to configure a DB2 UDB JDBC provider and data source for the business process container.

  1. 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.
  2. Change to the Business Process Choreographer directory: On Windows, enter:
    cd install_root\ProcessChoreographer
    On UNIX and Linux platforms, enter:
    cd install_root/ProcessChoreographer
  3. 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.
  4. 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.

Related information
Business process container installation wizard settings