Chapter 7. Data Management
7.1. Data Backups
When applying a backup mechanism to Red Hat JBoss BPM Suite, ensure you back up the following resources:
Any customized deployment descriptors (such as,
Any customized properties files.Note
Consider backing up the entire
JBOSS-HOME/bin/.niogitfolder. This directory contains Git repositories that Business Central manages internally to store project and configuration data.Note
The location of the
.niogitdirectory may be different based on your configuration. See the
7.2. Setup Indexes
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:
Note that ALL the columns in these two tables need to be indexed and not just the primary and foreign keys.
7.3. Setting up and Editing the Database
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.
7.4. DDL Scripts
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:
- Login to the Customer Portal.
- Click on Red Hat JBoss BPM Suite and select the version of the product for your requirements.
- Click on Download in the row Red Hat JBoss BPM Suite 6.4.0 Supplementary Tools to download the supplementary tools.
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.