Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 8 Setting Deployment Options : Configuring Storage for TIBCO BusinessWorks Processes

Configuring Storage for TIBCO BusinessWorks Processes
You can use TIBCO Administrator to configure the location where TIBCO BusinessWorks process engines store internal information.
Most of the information a process engine stores is information about each service’s state when a checkpoint is taken. There is, however, some other internal information stored by the engine. You can specify that this information is stored in the file system (the default) or in a database.
For some systems, using a file system for storage may be sufficient. However, some functionality is only available when you use a database for storing information about service state:
Specifying a Database for Storage
To configure a database for storage, follow these steps:
1.
2.
3.
Figure 49 Specifying a Database for Storage
4.
Database Table Names
When you specify a database for TIBCO BusinessWorks storage, tables are created in your database. The administration domain name and deployment ID (assigned by TIBCO BusinessWorks) are used to name the tables to ensure uniqueness of the tables for each domain and each deployment.
Because some databases limit the number and kinds of characters for table names, the domain name can altered before being used in the table name. The first eight characters and the last eight characters of the domain name are taken and any non-legal characters (such as spaces or dashes) are converted to underscores. This creates a sixteen-character unique ID for each domain, provided that the first and last eight characters of all of your domain names are unique.
For example, the following illustrates conversion of domain names. Notice the second and third domain names convert to the same ID. You should avoid this by creating domain names so that the combination of the first and last eight characters are unique.
All table names created by TIBCO BusinessWorks begin with APPLICATION_NAME_random number. You can alter the storage parameters for these tables if you desire, but the table names and column definitions must remain the same.
Manually Creating Database Tables
The process engine creates database tables used to store process engine information automatically. Some database administrators do not permit applications to automatically create tables. If you wish to manually create the database tables, TIBCO BusinessWorks provides template scripts for the supported databases in the TIBCO_BW_HOME/bin directory.
In these scripts TABLE_NAME_PREFIX and ENGINE_NAME_MAX_LENGTH are placed in the SQL code as placeholders. The TABLE_NAME_PREFIX is determined by default at deployment time (see Database Table Names for a description of how the table name prefix is determined). You can obtain this prefix by locating the Database.Tablename.Prefix property in the deployment configuration file and substituting its value where required in the template SQL script. ENGINE_NAME_MAX_LENGTH is 128, so supply that value instead of the placeholder in the SQL script.
To Manually Create the Tables
1.
2.
Before starting the process engine, examine the deployment configuration file (the processEngine.tra file) and locate the property Database.Tablename.Prefix.
3.
Edit the appropriate SQL script template for the database you are using and replace TABLE_NAME_PREFIX with the value of the Database.Tablename.Prefix property.
4.
Change ENGINE_NAME_MAX_LENGTH to 128.
5.
6.
7.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved