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, ActiveMatrix 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.

For a description about how the table name prefix is determined, see Database Table Names

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, perform the following procedure:

Procedure 

1. Create a deployment configuration that specifies a database for process engine storage. See Specifying a Database for Storage.
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. Save the changes to the SQL script.
6. Run the SQL script against the database you wish to use.
7. Start the process engine.