IBM BPM, V8.0.1, All platforms > Install IBM BPM > IBM BPM Advanced: Process Server > Install IBM BPM Advanced: Process Server > On AIX > Stand-alone environment > Typical installation and configuration > DB2 database server

Creating DB2 databases

IBM BPM requires a Process Server database, Performance Data Warehouse database, and Common database. The Common database contains Business Space and other components. You must make sure the databases are available before install IBM BPM using a typical installation.

The default database names are BPMDB for the Process Server database, PDWDB for the Performance Data Warehouse database, and CMNDB for the Common database.

The Process Server and Performance Data Warehouse require their own separate databases and cannot be configured on the same database as the other BPM components.

Procedure

Use the following command to create the databases for DB2 (replace the @ placeholder strings with the appropriate values):

create database @DB_NAME@ automatic storage yes  using codeset UTF-8 territory US pagesize 32768;
connect to @DB_NAME@;
grant dbadm on database to user @DB_USER@;
UPDATE DB CFG FOR @DB_NAME@ USING LOGFILSIZ 4096 DEFERRED;
UPDATE DB CFG FOR @DB_NAME@ USING LOGSECOND 64 DEFERRED;
connect reset;

Parent topic: Install IBM BPM with a DB2 database server