Creating a DB2 UDB for iSeries database for Business Process Choreographer

This topic describes how to create the database schema on DB2 for iSeries for Business Process Choreographer.

Perform this task on the application server machine.
  1. Make sure that you have DB2 Connect Gateway (Version 8.1, Fix Pack 3 or later) installed. This component is part of the DB2 UDB ESE package, but you can also install it separately.
    Draft comment:
    We try to avoid mentioning specific versions and fix packs - is this absolutely necessary?
  2. Catalog the remote database using the Add database wizard in the configuration assistant.
  3. Verify that you can establish a connection to the remote DB2 iSeries system by entering the following command:
     db2 connect to iSeries-database user userid using password
    where userid and password are the user ID and password that you use to connect to the database using Business Process Choreographer.
  4. If no collection is created for the user ID, enter:
    db2 create collection userid
  5. Change to the ProcessChoreographer subdirectory in the application server installation root directory.
  6. Run the createSchemaDb2iSeries.ddl script file, as described in the header of the script file. If you want to drop the schema, use the dropSchemaDb2iSeries.ddl script.
  7. To use the Toolbox JDBC driver, download it from your iSeries system. The necessary JAR file for this driver is: /QIBM/ProdData/Http/Public/jt400/lib/jt400.jar.
The DB2 for iSeries schema for Business Process Choreographer exists.