Creating the IBM Cognos BI database for the content store

If you migrated from a release of IBM® Business Monitor that did not include the IBM Cognos® Business Intelligence content store database, you must create the database that IBM Cognos BI uses for the content store. Otherwise, you can skip this step. IBM Cognos BI updates its content store database automatically when it first starts.

Figure 1. Sample environment after existing schemas and data are updated. The source environment is not running and the databases are not in use. The databases contain updated schemas and data. The target is not running.

The details of the diagram are provided in the figure caption.

Before you begin

If you want to use a remote database for the content store, ensure that a local database client is installed on the Cognos server and that the MONITOR database is cataloged. The cataloged database name must match the database name that is configured in the WebSphere® data source for the MONITOR database.

Procedure

To create the database that IBM Cognos BI will use for the content store, complete the following steps:

Open the following script in a text editor: V8.5.7_monitor_root\dbscripts\Cognos\Oracle\createDatabase.sql.
Replace the values for the following variables with the values for your environment:
- @COG_DB_PASSWORD@
- @TSDIR@
- @SCHEMA@
Save your changes and close the file.
Important: If you are using a remote database and prefer not to run the scripts on the installation program on the database server, you must copy the scripts to the database server before you continue.
From the command line, run the script to create the database: 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)