Running the generated PostgreSQL database scripts

Edit online

If you run the BPMConfig command with the property bpm.de.deferSchemaCreation set to true you must run the generated database scripts manually to create the database tables.

Before you begin

Before you begin this task, you must have run the BPMConfig command to generate the correct SQL scripts. You also need to have created the required databases using the generated database creation scripts.

If the bpm.de.deferSchemaCreation property is set to false, the SQL scripts used to create the database tables are automatically run when you create the deployment environment.

About this task

The database SQL scripts are generated in the dmgr_profile_name\dbscripts folder by default. This folder includes the following sub-folders:

cell_name.deployment_environment_name - For each deployment environment, this folder will contain the SQL files that need to be run.

Procedure

Locate the generated SQL scripts.
A default configuration for a Standard deployment environment with PostgreSQL databases contains the following sub-folders and SQL scripts:
- cell_name.deployment_environment_name
  - PostgreSQL
    - bpmdb
      
      schema_name
      
      createSchema_Standard.sql
      
      createProcedure_Standard.sql
    - pdwdb
      
      createSchema_Standard.sql
    - cpedb
      
      createSchema_Standard.sql
Run the scripts to apply the schema to the bpmdb.
Note: If you set bpm.de.deferSchemaCreation=true, connect to your databases before you run CreateSchema_Standard.sql and CreateProcedure_Standard.sql. For example:
```
\c xxxdb
SET ROLE xxx;
```
For example, use the following commands to run the scripts manually for the Process database configuration:
```
\c bpmdb
SET ROLE dbUser;
\i /bpmdb/createSchema_Standard.sql 
\i /bpmdb/createProcedure_Standard.sql
```
Run the scripts to apply the schema to the pdwdb. For example, use the following commands to run the scripts manually for the Performance Data Warehouse database configuration:
```
\c pdwdb
SET ROLE dbUser;
\i /pdwdb/createSchema_Standard.sql
```
Run the scripts to apply the schema to the cpedb. For example, use the following commands to run the scripts manually for the Content database configuration:
```
\c cpedb
SET ROLE dbUser;
\i /cpedb/createSchema_Standard.sql
```

What to do next

You must now run the bootstrap utility to load configuration data for the IBM® Business Automation Workflow applications into the Process database. This data is required for the applications to run correctly.

If your PostgreSQL database server uses certificate authentication, refer to the Enabling a NIST SP800-131a compliant environment to do SSL related configuration and then run the bootstrapProcessServerData command. After this, start the deployment manager and the IBM Business Automation Workflow server. The server will not start successfully, if you start the IBM Business Automation Workflow server without configuring the SSL.