The Common database is optionally created when you create a WebSphere Process Server profile. This database acts as a repository by various components. If you prefer you can create the database before creating the profile, or defer the database creation until after the creation of your profile.
There is one DBMS instance per cell.
The Common database is optionally created during profile creation using the profile action scripts. The profile action scripts are sample scripts. If you wish to use them to manually create your database tables you must edit them with your specific database information. If you use the scripts to manually create your database tables before you create a profile, you are then able to choose the option of using an existing database in the Profile wizard.
If you are creating WebSphere Process Server profiles using a profile creation script, the parameter -dbDelayConfig {true|false} must be set correctly. If set to true the database configuration is not performed during profile creation and you must use the provided scripts to configure the databases.
If you choose to defer creation of the database until after profile creation then default scripts, which include parameters gathered during profile creation, are created in the following location:
install_root/profiles/profileName/dbscripts/feature/dbType/dbName
The script naming convention is shown in Table 1.
Stand-alone profile
The profile action scripts are located in the following directory after installation of WebSphere Process Server:
install_root/dbscripts/CommonDB/dbType
or if you defer creation of the database until after you have created the profile the scripts will be found in:
install_root/profiles/profilename/dbscripts/CommonDB/dbType/dbName
The scripts are ready to execute, but you can edit them to include any specific requirements. If you try to start WebSphere Process Server before creating the database you will receive an error message.
Deployment manager profile
The profile action scripts are located at the following directory after installation of WebSphere Process Server:
install_root/dbscripts/CommonDB/dbType
or if you defer creation of the database until after you have created the profile the scripts will be found in:
install_root/profiles/profilename/dbscripts/CommonDB/dbType/dbName
The scripts are ready to execute, but you can edit them to include any specific requirements. If you try to start WebSphere Process Server before creating the database you will receive an error message.
Custom (managed) profile
The profile action scripts are located at the following directory after installation of WebSphere Process Server:
install_root/dbscripts/CommonDB/dbType
or if you defer creation of the database until after you have created the profile the scripts will be found in:
install_root/profiles/profilename/dbscripts/CommonDB/dbType/dbName
SQL scripts allow you to configure your database after profile creation. Tables are created with a deployment manager profile and so there are no SQL scripts executed as part of managed node creation.
SQL scripts for each Common database client can be found in the following locations:
install_root/dbscripts/CommonDB/dbType
or if you defer creation of the database until after you have created the profile the scripts will be found in:
install_root/profiles/profilename/dbscripts/CommonDB/dbType/dbName
If an appropriate JDBC provider does not exist one is created.
A data source is created with JNDI name jdbc/WPSDB.
There are several restrictions on the database commands that are available to the user during profile creation.
Component | Table names | Scripts |
---|---|---|
Recovery | FAILEDEVENTS FAILEDEVENTBOTYPES FAILEDEVENTMESSAGE | createTable_Recovery.sql |
Mediation | MEDIATION_TICKETS | createTable_mediation.sql |
Relationship | Dynamic table, created at runtime | createTable_Relationship.sql |
Application Scheduler | WSCH_LMGR WSCH_LMPR WSCH_TASK WSCH_TREG | createTable_AppScheduler.sql |
Customization (selector/business rule group) | BYTESTORE BYTESTOREOVERFLOW APPTIMESTAMP | createTable_customization.sql |
Common database | SchemaVersionInfo | createTable_CommonDB.sql |
install_root/profiles/profilename/dbscripts/CommonDB/dbType/dbName
Scripts are created for any option chosen on the Profile wizard panel used to configure the Common database (Create a new (local) database, Use an existing database, and Set up a new or existing database separately). The scripts contain only basic creation statements for databases, tables, and indexes. The database administrator must use database native commands to execute these scripts.
If the option Set up a new or existing database separately is selected, you can also create your database tables using the provided batch or shell file. The file invokes all the necessary scripts with the native database commands that are required to invoke them. The files are called configCommonDB.bat or configCommonDB.sh for Windows and UNIX-based operating systems, respectively. The file is created in the same directory as the scripts: install_root/profiles/profilename/dbscripts/CommonDB/dbType/dbName.
The user credentials that you provide in the Profile wizard should have sufficient permissions to be able to create tablespaces, tables, indexes, and stored procedures. For the Create a new (local) database option, the user identity must have the necessary privileges to create a new database.
Last updated: Wed 01 Nov 2006 07:47:12
(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)