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.

Steps for this task

  1. On UNIX, perform Configure WebSphere Application Server for DB2 access.
    Note: On Windows the environment is set up automatically.
  2. Change to the process choreographer directory:
    On Windows, enter:
    cd install_root\ProcessChoreographer
    On UNIX, enter:
    cd install_root/ProcessChoreographer
  3. Run the configuration script. It will create a data source that uses the DB2 Legacy CLI-based type-2 JDBC driver (XA).
    On Windows, enter:
    install_root\bin\wsadmin -f create_ds_Db2.jacl 
        [-node <nodeName>] -server <serverName> -dbPath <databasePath> 
        [-dbName <databaseName>] -userid <userID> -passwd <password>
    On UNIX, 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.

Results

The DB2 JDBC provider and data source have been configured for the business process container.

What to do next

Configure the queue resources.

Related tasks
Configuring WebSphere Application Server for DB2 access
Related reference
Business process container install wizard settings



Searchable topic ID:   t2codsdb
Last updated: Jun 21, 2007 8:07:48 PM CDT    WebSphere Business Integration Server Foundation, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.wasee.doc/info/ee/workflow/tasks/t2codsdb.html

Library | Support | Terms of Use | Feedback