IBM BPM, V8.0.1, All platforms > Install IBM BPM > IBM BPM Advanced > Install IBM BPM Advanced > On AIX > Stand-alone environment > Custom installation and configuration > Configure profiles and databases > DB2 database server

Create 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 create the databases before ND.

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

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;


What to do next

To use DB2 Universal Databaseā„¢:

If the procedure is not followed, you might see the following exceptions when creating or augmenting a profile.

Configure a stand-alone environment with a DB2 database server on AIX