Choosing a method for creating databases in the DB2 for z/OS subsystem

You can use the BPMConfig.sh or BPMConfig.bat script to generate the database scripts that are required for creating the databases for the IBM® Business Process Manager components.

This option is available when you are configuring for DB2 for z/OS only. You can use various tools to run these database scripts, based on personal preference, or the standards or conventions for the tools used in your organization:

When you run BPMConfig to generate the database scripts, the createDatabase.sh script is also generated. For each database, createDatabase.sh can create all your database objects in a single execution. Therefore, this tool is a good choice if this is your first server implementation.
You can use tools such as the DB2® command line processor, SPUFI, or DSNTEP2 to run the database scripts in the UNIX Systems Services environment or from a z/OS® environment. As an alternative to running the small number of SQL files individually, you can optionally choose to run the createDatabase.sh script in a mode that bypasses execution of the SQL statements, in order to consolidate them into two SQL files. You can run these files by using the DB2 command line processor, SPUFI, or DSNTEP2.
Note: The SQL files that you need to run are in ASCII format. If you intend to use tools like the SQL processor using file input facility (SPUFI) or DSNTEP2 to run the SQL statements, some manual effort might be required to reformat SQL statements that exceed 71 characters in length after EBCDIC conversion. You can use the lineLength.sh utility to help you identify and fix SQL statements that exceed 71 characters in length.