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,
web.xml,jboss-web.xml,jboss.xml). Any customized properties files.
NoteConsider backing up the entire
business-central.waranddashbuilder.warfiles.The
JBOSS-HOME/bin/.niogitfolder. This directory contains Git repositories that Business Central manages internally to store project and configuration data.NoteThe location of the
.niogitdirectory may be different based on your configuration. See theorg.uberfire.nio.git.dirsystem property.
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: processinstancelog and bamtasksummary.
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.
Where did the comment section go?
Red Hat's documentation publication system recently went through an upgrade to enable speedier, more mobile-friendly content. We decided to re-evaluate our commenting platform to ensure that it meets your expectations and serves as an optimal feedback mechanism. During this redesign, we invite your input on providing feedback on Red Hat documentation via the discussion platform.