Open topic with navigation

TIBCO® BPM Enterprise 5.5.0

# 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:

    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

Note: The BPME database tables are generated automatically using the BPME utility.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO® BPM Enterprise

Copyright © 2015-2024. Cloud Software Group, Inc. All Rights Reserved.