Set Up the Database Client for the Metric Store

If you are using a database other than Microsoft SQL as a metric store, you may have to install database client software, or JDBC drivers, or both, on each computer where you install the Application Tier Components for Cognos Metrics Manager. Doing this allows Application Tier Components to access the metric store database.

Important: If you use a DB2 database for the content store, notification database, or logging database, you can use the universal JDBC driver file, db2jcc.jar. However, if you use a DB2 database for the metric store, you must use the JDBC2 driver, db2java.zip. If you use the universal JDBC driver, you will not be able to create new metrics packages or access existing metrics packages.

Steps for DB2

1. Install the DB2 client software on the Application Tier Components computer.

2. If the metric store is on a different computer from the Application Tier Components, configure a database alias to the metric store by running the DB2 Client Configuration Assistant.

   On UNIX or Linux, use the DB2 command line interface.

   If the metric store database and the Application Tier Components are on the same computer, the metric store name automatically becomes the alias.

3. On Windows, stop the DB2 services and the HTML Search Server.

4. To copy the JDBC2 driver, copy the DB2_installation/sqllib/java/db2java.zip file to the c8_location/webapps/p2pd/WEB-INF/lib directory.

5. Rename the db2java.zip file to db2java.jar.

6. On Windows, restart the DB2 services and the HTML Search Server.

Steps for Oracle

1. On the computer where the Oracle client is installed, go to the ORACLE_HOME/jdbc/lib directory.

2. Copy the ojdbc14.jar file (or, for Oracle 11g, the ojdbc5.jar file) to the c8_location/webapps/p2pd/WEB-INF/lib directory on computers where Content Manager is installed.

   If the directory contains the classes12.jar file, delete it before installing the ojdbc14.jar or ojdbc5.jar file.

   The driver is available from an Oracle client or server install, and it can also be downloaded from the Oracle technology Web site (http://www.oracle.com/technology).

3. Install the SQL Loader utility on the computer where Application Tier Components are installed.

Steps for Sybase

1. On the computer where Sybase is installed, go to the Sybase_location/jConnect-5_5/classes directory.

2. Copy the jconn2.jar file to the c8_location/webapps/p2pd/WEB-INF/lib directory on every computer where Content Manager is installed.

Step for Microsoft SQL

• Install the bcp utility on every computer where Application Tier Components for IBM Cognos 8 Metrics Manager are installed.