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
profile_name\dbscripts folder
by default. This folder includes the following
sub-folder:- 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 an Express deployment
environment with DB2 databases contains the following sub-folders
and SQL scripts:- cell_name.deployment_environment_name
- DB2
- CMNDB
- createSchema_Express.sql
- createSchema_Messaging.sql
- BPMDB
- createSchema_Express.sql
- createProcedure_Express.sql
- Run the scripts to
apply the schema to the CMNDB.
For example, use the following
commands to run the scripts manually for a
deployment environment-level Common
database configuration:
db2 connect to CMNDB USER username USING password
db2 -tvf profiles\Server1Profile\dbscripts\cell_name.deployment_environment_name\DB2\CMNDB\createSchema_Express.sql
db2 -tvf profiles\Server1Profile\dbscripts\cell_name.deployment_environment_name\DB2\CMNDB\createSchema_Messaging.sql
db2 connect reset
- Run the scripts to
apply the schema to the BPMDB.
For example, use the following
commands to run the scripts manually for Process database configuration:
db2 connect to BPMDB USER username USING password
db2 -tvf profiles\Server1Profile\dbscripts\cell_name.deployment_environment_name\DB2\BPMDB\createSchema_Express.sql
db2 -tdGO -vf profiles\Server1Profile\dbscripts\cell_name.deployment_environment_name\DB2\BPMDB\createProcedure_Express.sql
db2 connect reset
- Run the scripts to
apply the schema to the PDWDB.
For example, use the following
commands to run the scripts manually for Performance Data Warehouse
database configuration:
db2 connect to PDWDB USER username USING password
db2 -tvf profiles\Server1Profile\dbscripts\cell_name.deployment_environment_name\DB2\PDWDB\createSchema_Express.sql
db2 connect reset
What to do next
You must now
run the bootstrap utility to load configuration data for the IBM® Business Process Manager applications
into the Process database. This data is required for the applications
to run correctly.