IBM BPM, V8.0.1, All platforms > Install IBM BPM > Plan for IBM BPM > Plan the database configuration

Choose how and when to configure the common database

If you are configuring a stand-alone server using DB2 Express, the database objects, including tables, are created automatically during configuration. If, however, you are using a database other than DB2 for a stand-alone or ND node, create the database objects later by using the scripts that are generated during the configuration or from the database design tool.You can create the required database tables either before or after configuring IBM BPM. The important thing to remember is that the databases (including their tables, schemas, and so on) must exist before the IBM BPM servers try to use them.

If you are planning to configure Business Process Choreographer, see Plan the topology, setup, and configuration path.

You can create the common database before, during, or after you create the IBM BPM profile.

• Before you configure IBM BPM:
  • Edit and run the default scripts that come with IBM BPM. You can use the default scripts to create only the common database and Business Process Choreographer tables.

  • Use the design file that was created using the database design tool (DDT).

• After you configure IBM BPM:

  • Use pmt.sh to configure IBM BPM to work with the tables in the database as you create the profile. You can create and configure the database tables during profile creation, or delay creation and configuration until after the profile has been created. Use pmt.sh to generate database scripts that you can use to create and configure the database tables. These generated scripts are ready to use. No editing is required.

  • Use the design file created using the database design tool (DDT).

Plan the database configuration

Related tasks:
Create database design files for DB2
Create database design files for Oracle
Create database design files for DB2 for z/OS
Create database design files for SQL Server