Creating a Database to Hold the BDS Case Data Store (DB2 Only)

Create a DB2 database and create a database user to access it.

Note: You only need to perform this task if you intend to host the BDS case data store on a separate DB2 database to the ActiveMatrix BPM database.

You can skip this task if you intend to host the BDS case data store in the ActiveMatrix BPM database, or if you intend to use a separate BDS database on a platform other than DB2 (in that case, the database is created automatically).

Procedure

  1. Create an empty database which will be used to hold the BDS case data store - for example, cds.
  2. Create a database user (or identify an existing one) for the BPM system to use to connect to this database - for example, bpm_cds_user. Make sure that the user exists in the database. Make sure that the database is available.
    Note: If you are upgrading, you cannot specify the details of this database as part of the upgrade process (when you run the Upgrade TIBCO ActiveMatrix BPM Instance Wizard).

    Instead, you will need to manually configure the DataSourceBDS JDBC resource template with these details as a post-installation task. See Configuring the DataSourceBDS Shared Resource.