If you need new SQL Server databases, create the
databases before creating your deployment environment. Even if you
have no new databases, validate that all database connections are
correctly configured before you continue.
Procedure
For each deployment environment that
you are creating, complete the following steps:
- Create required databases.
- Create a database for Process Server if you are migrating to IBM® BPM
Advanced. The
Process Server and Performance Data Warehouse require their own separate
databases and cannot be configured on the same database as the other
BPM components. The default name for the Process Server database is
BPMDB.
- Create a database for Performance Data Warehouse if you are migrating
to IBM BPM
Advanced.
The Process Server and Performance Data Warehouse require their own
separate databases and cannot be configured on the same database as
the other BPM components. The default name for the Performance Data
Warehouse database is PDWDB.
- Create a database for Business Space if you did not have one in
the source environment.
- Create a common database for each deployment environment if you
are migrating from multiple deployment environments.
- Create a messaging engine database if you want to use a single
messaging engine bus in the new environment (recommended). If you
want to use multiple buses, you can reuse the previous messaging engine
database and schema.
For each database, make any required changes
and run the following script:
For Process Server and Performance Data
Warehouse databases, run: install_root\BPM\dbscripts\SQLServer\Create\createDatabase_CaseInsensitive.sql
For
other databases, run:
install_root\BPM\dbscripts\SQLServer\Create\createDatabase_CaseSensitive.sql
- On the target deployment manager computer,
validate that all database connections are correctly configured by
running the BPMConfig -validate command. Use
the following syntax:
target_install_root\bin\BPMConfig -validate -db configuration_properties_file
where - configuration_properties_file is the full path
and name of the properties file that you copied over to the target
environment after you extracted information using the BPMConfig
-migrate command. Update the properties in the file for any
new databases that you created.
The command checks each connection and
displays a message similar to the following message:
A JDBC connection to the 'BusinessSpaceDb' (CMNDB.bpmadmin) has been successfully established.
Results
After all connections are checked,
you see a message that the BPMConfig -validate command
completed successfully.