Creating and configuring databases

Creating and configuring WebSphere® Business Monitor databases is a critical phase in the installation process.

The WebSphere Business Monitor has four databases:

At WebSphere Business Monitor installation, the databases can only be created using the Launchpad. If the databases are dropped after installation, you can re-create them using the Launchpad or manually. Creating the databases includes creating the static tables, table spaces, and indexes and setting the appropriate database configurations. The State, Runtime, and Historical databases contain both static and dynamic tables; the Repository database contains static tables only. The scripts required to create the databases are saved in <monitor_installation_dir\install\mondb.

To create the databases manually, perform the following steps in sequence:
  1. On Windows® system:
    1. Go to Start -> Programs -> IBM DB2 -> Command Line Tools -> Command Window.
    2. To create the Repository database, run the script: db2CreateRepository.bat <%RepositoryDatabaseName%> <%DB2userID%> <DB2Password> Create_Repository.sql <%Install_Directory%>.
    3. To create the State database, run the script: db2CreateState.bat createStateDB.ddl <%Install_Directory%>.
    4. To create the Runtime database, run the script: db2CreateRuntime.bat createRuntimeDB.ddl <%Install_Directory%>.
    5. To create the Historical database, run the script: db2CreateHistorical.bat createDatamartDB.ddl <%Install_Directory%>.
    Note: <%Install_Directory%> is "C:\IBM\Websphere\Monitor" by default.
  2. On AIX® system:
    1. Login as the DB2® instance user.
    2. To create the Repository database, run the script: db2CreateRepository.sh <%RepositoryDatabaseName%> <%DB2userID%> <DB2Password> <%PathToDDL%>/Create_Repository.sql <%Install_Directory%>.
    3. To create the State database, run the script: db2CreateState.sh <%PathToDDL%>/createStateDB.ddl <%Install_Directory%> <%DB2UserID%>.
    4. To create the Runtime database, run the script: db2CreateRuntime.sh <%PathToDDL%>/createRuntimeDB.ddl <%Install_Directory%> <%DB2UserID%>.
    5. To create the Historical database, run the script: db2CreateHistorical.sh <%PathToDDL%>/createDatamartDB.ddl <%Install_Directory%> <%DB2UserID%>.
    Note:
    • If you installed to an alternate directory, you will have to substitute the appropriate paths based on your installation directory.
    • <%PathToDDL%> is /opt/IBM/Websphere/Monitor/Install/mondb by default.
    • <%Install_Directory%> is /opt/IBM/Websphere/Monitor by default.
    • <%DB2UserID%> is db2inst1 by default.
Related concepts
State database
Database replication
Runtime database
Databases creation and deployment
Database artifacts deployment
Business Measures Model deployment scenarios
Artifacts customization
Related tasks
Managing databases at run time
Deploying Cube Views database schema on the Windows platform
Deploying data movement services
Running the Launchpad

Copyright IBM Corporation 2005, 2006. All Rights Reserved.