Configuring a DB2 UDB for z/OS JDBC provider and data source for the business process container

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

  1. Change to the Business Process Choreographer directory: On Windows platforms, enter:
    cd install_root\ProcessChoreographer
    On UNIX and Linux platforms, enter:
    cd install_root/ProcessChoreographer
  2. Run the configuration script. This script creates a data source for DB2 UDB for z/OS that uses the DB2 type-2 JDBC driver (XA). On Windows platforms, enter:
    install_root\bin\wsadmin -f create_ds_Db2_zos.jacl 
        [-node <nodeName>] -server <serverName> -dbPath <databasePath> 
        [-subsystem <subsystem>] -userid <userid> -password <password>
    On UNIX and Linux platforms, enter:
    install_root/bin/wsadmin.sh -f create_ds_Db2_zos.jacl 
        [-node <nodeName>] -server <serverName> -dbPath <databasePath> 
        [-subsystem <subsystem>] -userid <userid> -password <password>
    Where:
    wsadmin
    The script located in the bin subdirectory of the application server installation directory.
    create_ds_Db2_zos.jacl
    The script file that performs the configuration within the application server. It is located in the ProcessChoreographer subdirectory of the application server installation directory. For example, on a default Windows installation, it is in the directory c:\Program Files\WebSphere\AppServer\ProcessChoreographer.
    nodeName
    The optional node name.
    serverName
    The application server name.
    dbPath
    The location where your DB2 Connect is installed. Note: Even on windows you must use the forward slash /. For example, c:/sqllib.
    subsystem
    The cataloged subsystem name. If you do not provide a name the default, BPEDB, will be used.
    userid
    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
    The password for userid.
  3. If you had problems using the script, you can perform Using the administrative console to configure the JDBC provider and data source.

The DB2 z/OS CLI-based type 2 JDBC provider and data source have been configured for the business process container.

Configure the queue resources.

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