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.
- 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?
- Catalog the remote database using the Add database wizard in the configuration assistant.
- 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.
- If no collection is created for the user ID, enter:
db2 create collection userid
- Change to the ProcessChoreographer subdirectory in the application server installation root directory.
- 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.
- 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.