Creating DB2 for z/OS databases and validating database connections

For each deployment environment that you are creating, complete the following steps:

1. Create required databases.
   If you are migrating to a Standard deployment environment:

   • Create a database for Business Space if you did not have one in the source environment.
   • 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.

   If you are migrating to an Advanced deployment environment:

   • Create a database for Business Space if you did not have one in the source environment.
   • Create a Business Process Choreographer database.
   • 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:

   install_root\BPM\dbscripts\DB2zOS\Create\createDatabase.sql

   Use the DB2 command line processor to run the createDatabase.sql files on the database server; for example:

   db2 -tvf cell_scoped_subdir/createDatabase.sql

   db2 -tvf cluster_scoped_subdir/createDatabase.sql

2. 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.