Installing the COGNOSCS database manually

You can use the createDatabase script, or, for DB2® for z/OS®, the createDatabase_Cognos script, to install the IBM® Cognos® Business Intelligence content store database manually, either on the same server as the IBM Business Monitor server or as a remote database on another server. Before running the script, ensure that the environment-specific variables in the script have been configured manually.

Before you begin

Before you complete this task, make sure that you have read "Database considerations" and any prerequisites for your specific database product.

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/Cognos 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/Cognos).
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.
- DB2: db2 -tf createDatabase.sql
- DB2 for z/OS: db2 -tf createDatabase_Cognos.sql. The database script 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
For DB2 for z/OS only:
1. On DB2 for z/OS, you must create the table spaces using the IBM Cognos BI scripts tablespace_db2zOS.sql and NC_TABLESPACES.sql. See the full instructions in the IBM Cognos BI information center:
  - Suggested settings for creating the content store in DB2 on z/OS
  - Creating tablespaces for a content store on DB2 for z/OS
2. The first time IBM Cognos BI starts, it creates the tables using the following scripts:
  - COGNOS_location/configuration/schemas/content/db2zOS/dbInitTest_db2zOS.sql
  - COGNOS_location/configuration/schemas/content/db2zOS/dbInitScript_db2zOS.sql
  - COGNOS_location/configuration/schemas/content/db2zOS/dbInitLock_db2zOS.sql
  - COGNOS_location/configuration/schemas/content/db2zOS/dbInitMeta_db2zOS.sql
  - COGNOS_location/configuration/schemas/delivery/zosdb2/NC_CREATE_DB2.sql
  For network deployment (ND) environments, the initial server startup will first copy these files from the master IBM Cognos BI installation location to the server location. Make sure that you have replaced the environment-specific variables in these files before the IBM Cognos BI server starts; otherwise the table creation scripts will fail when the server starts. To determine your COGNOS_location, see Locating your runtime IBM Cognos BI root directory.
Start WebSphere® Application Server.