Creating DB2 databases

You must create the required databases before the installation of IBM® Business Process Manager. Usually you require the Process database, the Performance Data Warehouse database, and the Common database.

If you have an existing local DB2 server on your system, you can choose to create the required databases as part of the installation. Otherwise, you must create the databases before you install IBM Business Process Manager, as described in this topic.

About this task

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

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

Procedure

Use one of the following methods to create each database that you require:

Create and run the createDatabase.sql file as described in the following substeps:

Save the following SQL statements into a file named createDatabase.sql:

create database @DB_NAME@ automatic storage yes  using codeset UTF-8 territory US pagesize 32768;
connect to @DB_NAME@;
-- A user temporary tablespace is required to support stored procedures in BPM
create user temporary tablespace usrtmpspc1;
grant dbadm on database to user @DB_USER@;
UPDATE DB CFG FOR @DB_NAME@ USING LOGFILSIZ 16384 DEFERRED;
UPDATE DB CFG FOR @DB_NAME@ USING LOGSECOND 64 DEFERRED;
connect reset;

In the SQL statements, replace @DB_NAME@ with the name that you want to use for the created database and replace @DB_USER@ with the user name that you want to use for the database.
Run the following command to create the database:
```
db2 -tvf createDatabase.sql
```

Run SQL statements in a command editor as described in the following substeps:
1. Copy the following SQL statements into a command editor:
```
create database @DB_NAME@ automatic storage yes  using codeset UTF-8 territory US pagesize 32768;
connect to @DB_NAME@;
-- A user temporary tablespace is required to support stored procedures in BPM
create user temporary tablespace usrtmpspc1;
grant dbadm on database to user @DB_USER@;
UPDATE DB CFG FOR @DB_NAME@ USING LOGFILSIZ 16384 DEFERRED;
UPDATE DB CFG FOR @DB_NAME@ USING LOGSECOND 64 DEFERRED;
connect reset;
```
2. In the SQL statements, replace @DB_NAME@ with the name that you want to use for the created database and replace @DB_USER@ with the user name that you want to use for the database.
3. Run the SQL statements in the command editor.
Note: If a command fails to execute from the DB2 command prompt, remove the semicolon (;) and rerun the command.