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 toStart -> 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/mondbby default.
    • <%Install_Directory%> is /opt/IBM/Websphere/Monitor by default.
    • <%DB2UserID%> is db2inst1 by default.

Copyright IBM Corporation 2005, 2006. Všechna práva vyhrazena.