Installing the MONITOR database manually

You can use database scripts to install the IBM® Business Monitor database manually, either on the same server as the IBM Business Monitor server or as a remote database on another server. Before running the scripts, ensure that the environment-specific variables in the scripts have been manually configured.

Before you begin

Before you complete this task, make sure that you have read "Database considerations" and any prerequisites for your specific database product. For example, if you are using DB2® for z/OS®, a dedicated storage group (STOGROUP) is recommended for IBM Business Monitor. The storage group must be created before the database is created.

Procedure

Complete the following steps on the server where the database software is installed:

Log in to the database server as a user with authority to create table spaces and database objects.
Locate the DDL scripts.
- If you are using the scripts that are delivered when IBM Business Monitor is installed, they are found in the app_server_root/dbscripts/Monitor directory.
- If you had profile creation generate the scripts with your variable values substituted, they are in the output directory that you chose when creating the profile (by default app_server_root/profiles/<profile>/dbscripts/Monitor).
Update the script if required; for example, to add the password. From the command line, run the script, using the following command for your database software. The script creates the database for IBM Business Monitor.
- DB2: db2 -tf createDatabase.sql
- DB2 for z/OS:
  - db2 -tf createDatabase_Monitor.sql
  - db2 -tf createTablespace_Monitor.sql
  The database scripts can be run using either the SPUFI or the DSNTEP2 utility.
- Oracle: sqlplus dbadmin/password@database_name @createDatabase.sql where
  - dbadmin is an Oracle user with administrative authority
  - database_name is the Oracle ID (for example, orcl)
- Microsoft SQL Server: sqlcmd -U dbadmin -P password -e -i createDatabase.sql where
  - dbadmin is a SQL Server user with administrative authority
Run the script to create tables using one of the following commands:
- DB2:
```
db2 connect to MONITOR
db2 -tf createTables.sql
db2 connect reset
```
  Note: While running the DDL file, you might see the following warning message: SQL0347W The recursive common table expression "MON023.WBITIME" may contain an infinite loop. SQLSTATE=01605. You can safely ignore this message.
- DB2 for z/OS :
```
db2 connect to MONITOR
db2 -tf createTable_Monitor.sql
db2 connect reset
```
  Note: While running the DDL file, you might see the following warning message: SQL0347W The recursive common table expression "MON023.WBITIME" may contain an infinite loop. SQLSTATE=01605. You can safely ignore this message.
- Oracle: sqlplus user/password@database_name @createTables.sql
- Microsoft SQL Server: sqlcmd -U user -P password -e -i createTables.sql
Start WebSphere® Application Server.