If you run the BPMConfig command
with the property bpm.de.deferSchemaCreation set
to true, or if you used the Deployment Environment
wizard and cleared the Create Tables option,
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 or the Deployment Environment
wizard 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, or if you used the Deployment Environment
wizard and did not clear the Create Tables option,
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 - If you are
configuring an Advanced or Advanced-only deployment environment, this
folder contains the SQL files for the CommonDB database that is configured
on the cell.
- 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 Advanced deployment
environment with SQL Server databases contains the following sub-folders
and SQL scripts:- cell_name
- SQLServer
- CMNDB
- schema name
- createSchema_Advanced.sql
- cell_name.deployment_environment_name
- SQLServer
- CMNDB
- schema name
- createSchema_Advanced.sql
- createSchema_Messaging.sql
- BPMDB
- schema name
- createSchema_Advanced.sql
- createProcedure_Advanced.sql
- PDWDB
- schema name
- createSchema_Advanced.sql
Note: The BPMDB and PDWDB folders
for Process Server and Performance Data Warehouse databases are not
generated for an Advanced-only deployment environment.
- Run the scripts to
apply the schema to the CMNDB.
For
example, use the following commands to run the scripts manually for
a
cell-scoped Common database configuration:
sqlcmd -U @DB_USER@ -P @DB_PASSWD@ -d CMNDB -i profiles\DmgrProfile\dbscripts\cell_name\SQLServer\CMNDB\schema1\createSchema_Advanced.sql
For
example, use the following commands to run the scripts manually for
a
deployment environment-level Common database configuration:
sqlcmd -U @DB_USER@ -P @DB_PASSWD@ -d CMNDB -i profiles\DmgrProfile\dbscripts\cell_name.deployment_environment_name\SQLServer\CMNDB\schema1\createSchema_Advanced.sql
sqlcmd -U @DB_USER@ -P @DB_PASSWD@ -d CMNDB -i profiles\DmgrProfile\dbscripts\cell_name.deployment_environment_name\SQLServer\CMNDB\schema1\createSchema_Messaging.sql
In the above and following examples, schema1 is
the name of the schema used.
- Run the scripts to
apply the schema to the BPMDB.
For example, use the following
commands to run the scripts manually for the Process database configuration:
sqlcmd -U @DB_USER@ -P @DB_PASSWD@ -d BPMDB -i profiles\DmgrProfile\dbscripts\cell_name.deployment_environment_name\SQLServer\BPMDB\schema1\createSchema_Advanced.sql
sqlcmd -U @DB_USER@ -P @DB_PASSWD@ -d BPMDB -i profiles\DmgrProfile\dbscripts\cell_name.deployment_environment_name\SQLServer\BPMDB\schema1\createProcedure_Advanced.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:
sqlcmd -U @DB_USER@ -P @DB_PASSWD@ -d PDWDB -i profiles\DmgrProfile\dbscripts\cell_name.deployment_environment_name\SQLServer\PDWDB\schema1\createSchema_Advanced.sql
What to do next
If
you created a Standard deployment environment or an Advanced deployment
environment, 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.