If you postponed creating the Common
database tables until after profile creation, you or your database
administrator must create the tables manually. You can use the scripts
that the Profile Management Tool generates during profile creation
or augmentation.
Before you begin
You have performed the following actions:
- Created or augmented a deployment manager profile.
- Chosen not to run the database scripts to initialize the databases
during the configuration.
- Created the database that you want to create the Common database
tables in. The default name for the Common database is CMNDB.
Procedure
- Go to the directory containing the configCommonDB.sh script. The default directory is install_root/profile/dbscripts/CommonDB/SQLServer/.
- Use your standard database definition
tools, native commands, and procedures to create the database and
required tables by running this script. The script contains only basic statements
for creating databases, tables, and indexes.
The variable db_type represents
the supported database product and db_name represents
the name of the database.
You must pass the createDB parameter
to the script if you want to create a new local database; otherwise
an existing database will be used.
Run one of the following commands:configCommonDB.sh
createDB - creates the database and tables
configCommonDB.sh -
creates only the tables and assumes that the database already exists
Alternatively, you could customize
and run the individual scripts manually in the following order:- Run createDatabase_CommonDB.sql if the Business
Space database and the CommonDB are not the same database instance,
and then connect to the database created.
- createTable_AppScheduler.sql
- createTable_CommonDB.sql
- createTable_customization.sql
- createTable_DirectDeploy.sql
- createTable_EsbLoggerMediation.sql
- createTable_governancerepository.sql
- createTable_lockmanager.sql
- createTable_mediation.sql
- createTable_Recovery.sql
- createTable_RelationshipService.sql
- insertTable_CommonDB.sql