Configuring a DB2 UDB for iSeries JDBC provider and data source for the business process container

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

  1. On UNIX, perform Configure WebSphere Application Server for DB2 access. 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, enter:
    cd install_root/ProcessChoreographer
  3. 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.
  4. 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.

Parent topic: Using a script to configuring the JDBC provider and data source for the business process container