Creating and configuring WebSphere® Business Monitor databases
is a critical phase in the installation process.
The
WebSphere Business Monitor has four
databases:
- Repository
- State
- Runtime
- Historical
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:
- On Windows® system:
- Go to Start -> Programs -> IBM DB2 -> Command Line
Tools -> Command Window.
- To create the Repository database, run the script: db2CreateRepository.bat <%RepositoryDatabaseName%> <%DB2userID%> <DB2Password>
Create_Repository.sql <%Install_Directory%>.
- To create the State database, run the script: db2CreateState.bat
createStateDB.ddl <%Install_Directory%>.
- To create the Runtime database, run the script: db2CreateRuntime.bat
createRuntimeDB.ddl <%Install_Directory%>.
- To create the Historical database, run the script: db2CreateHistorical.bat
createDatamartDB.ddl <%Install_Directory%>.
Note: <%Install_Directory%> is "C:\IBM\Websphere\Monitor" by
default.
- On AIX® system:
- Login as the DB2® instance user.
- To create the Repository database, run the script: db2CreateRepository.sh <%RepositoryDatabaseName%> <%DB2userID%> <DB2Password> <%PathToDDL%>/Create_Repository.sql <%Install_Directory%>.
- To create the State database, run the script: db2CreateState.sh
<%PathToDDL%>/createStateDB.ddl <%Install_Directory%> <%DB2UserID%>.
- To create the Runtime database, run the script: db2CreateRuntime.sh
<%PathToDDL%>/createRuntimeDB.ddl <%Install_Directory%> <%DB2UserID%>.
- 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.