Chapter 7. Data Management

When applying a backup mechanism to Red Hat JBoss BPM Suite, ensure you back up the following resources:

Setup Foreign Key Indexes

Some databases, for instance Oracle and PostgreSQL, do not automatically create an index for each foreign key. This can result in deadlocks occurring. To avoid this situation, it is necessary to create an index on all foreign keys, especially in the Oracle database.

Setup Indexes for Process and Task Dashboard

Process and Task Dashboard in 6.1 has been refactored in order to cope with high volume of task and process instances. In order to get good response times while querying the database the following JBoss BPM Suite tables need to be indexed: processinstancelog and bamtasksummary.

Note that ALL the columns in these two tables need to be indexed and not just the primary and foreign keys.

For information on how to change the database for Red Hat JBoss BPM Suite, see Persistence Setups of the Red Hat JBoss BPM Suite Installation Guide.

DDL scripts for database tables for Red Hat JBoss BPM Suite are available for download on the Customer Portal. These scripts allow you to study the tables and use them to create the tables and indexes manually or in databases that are not directly supported.

To download these scripts:

Unzip the file on your machine. The DDL scripts are located in the ddl-scripts directory. Database scripts are provided for DB2, H2, MySQL5, Oracle, PostgreSQL, and SQLServer.

The complete Entity Relationship diagram can be viewed in this Red Hat Solution.