Creating Database Using IBM DB2

The following procedure describes the steps to create an IBM DB2 database instance for TIBCO BPM Enterprise, to configure, and to start the database.

    Procedure

  1. 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.)

  2. Start the database.

  3. Create a new, empty database that can be used to store the BPM Enterprise database tables.
  4. Set the database page size to 16384 and other required options by using the following commands:
    5. db2 create database bpm pagesize 16384
db2 connect to bpm user db2inst1 using db2inst1
db2 create tablespace systoolspace in ibmcatgroup managed by automatic storage extentsize 4
db2 create user temporary tablespace systoolstmpspace in ibmcatgroup managed by automatic storage extentsize 4
db2 disconnect all
  5. As the database administrator, run the following script to create the bpmuser role (user). TIBCO BPM Enterprise uses this role whenever it connects to the BPM database. 
    CONFIG_HOME/tibco/cfgmgmt/bpm/database/db2/createuser.sql
    6. Note: The BPME database tables are generated automatically using the BPME utility.