Creating or configuring database scripts using the database design tool

The database design tool (DbDesignGenerator) installed with the IBM® Business Monitor server can be used to generate database scripts that can be executed before or after IBM Business Monitor profile creation.

About this task

One advantage of using the database design tool is that you can design the databases for IBM Business Monitor, IBM Cognos® BI, Business Space, and the messaging engine all at the same time. Database scripts are generated for each component, and a dbdesign file is generated that can later be passed into the deployment environment wizard, to automatically configure the data sources when creating a complex IBM Business Monitor topology.

Important: Make sure you use the database design tool when you are creating databases for DB2® for z/OS®.

If you choose the Advanced path through the Profile Management Tool, you can choose Configure the database using a design file and select a design file that you have already created.

For more information about the database design tool, see the related links.

Procedure

To edit the database script files using the database design tool, complete the following steps:

Change directory to the app_server_root/util/dbUtils directory.
Run the command to start the utility.
- DbDesignGenerator.bat
- DbDesignGenerator.sh.
From the main menu, select option (1) Create a database design for Standalone profile or Deployment Environment.
At the Please pick one of the following db designs that are supported prompt, select either option (1)monitor.nd.topology or option (2)monitor.standalone. The monitor.nd.topology option provides more flexibility for distributing the database components across multiple databases.
At the Please pick one of the following [database component(s)] prompt, select option (1)[Monitor] MONITOR : [master] [status = not complete].
At the Edit this db component? prompt, enter y.
At the Please pick one of the following DB types that are supported prompt, select the number of your database platform.
Respond to the series of prompts or press Enter to accept the defaults where applicable. You are asked to enter your database name, schema name, user name and password, and table space location directory prefix.
At the To skip data source properties, enter 's'; or enter anything else to continue prompt, enter c (or any character except s) to continue entering information.
Respond to the series of prompts or press Enter to accept the defaults where applicable. You are asked to enter the properties for your data source.
Verify that the IBM Business Monitor database component is complete before configuring the other components. The IBM Cognos BI database is shown as not complete and requires a database user and password. You can accept the defaults for the other settings.
When you see the Please pick one of the following [database component(s)] prompt again, you have finished entering properties if all the lines display [status = complete], for example (1)[Monitor] MONITOR : [master] [status = complete]. Enter 5 [save and exit] and press Enter to save the database design.
The [Cognos] COGNOSCS database component requires additional configuration after completing the MONITOR configuration. The COGNOSCS status is [status = not complete] until this component is fully configured.
At the Please enter the output directory prompt, press Enter to accept the default (app_server_root/util/dbUtils) or enter the location to write the database design files.
At the Please enter the output filename prompt, press Enter to accept the default (monitor.standalone.dbdesign) or enter the name for the file.
At the Generate db script? prompt, enter y and keep pressing Enter to accept the default locations. Subdirectories are created for the MONITOR and COGNOSCS database scripts, messaging engine datastore script, and Business Space database scripts.