Configuring the BPM Database Server Using DB2

Create a DB2 database, configure it, and start it.

Procedure

  1. Create a new, empty database that will be used to hold the ActiveMatrix BPM database tables.

    You will specify this database name as part of the URL field in the ActiveMatrix BPM: Database Administrator and ActiveMatrix BPM: Runtime Database Configuration screens when you run the Create TIBCO ActiveMatrix BPM Server Wizard.

    Note: The ActiveMatrix BPM database tables (for each BPM system) and ActiveMatrix Administrator database tables must use separate databases.
  2. Set the database page size to 16384.
  3. Make sure that the DB2 cur_commit database configuration parameter is set to ON.
  4. Make sure that the SYSTOOLSPACE tablespace exists. If it does not, create it. Some BPM installation scripts require access to this tablespace.
  5. Create a suitable 32K temporary tablespace.

    For example:

    db2 "CREATE BUFFERPOOL tbsp_pool PAGESIZE 32K"

    db2 "CREATE SYSTEM TEMPORARY TABLESPACE tmp_tbsp PAGESIZE 32K MANAGED BY SYSTEM          USING ('/tmp/tmp_tbsp') BUFFERPOOL tbsp_pool"

  6. Create an operating system user account for the BPM system to use to connect to the BPM database - for example, bpmuser. (Alternatively, you can identify an existing operating system account to use.)

    You will specify this user in the Username field of the ActiveMatrix BPM: Runtime Database Configuration screen when you run the Create TIBCO ActiveMatrix BPM Server Wizard.

  7. Start the database.