and Framework Manager work
in your environment.If you use Oracle, DB2, or Sybase as the database server for the content store, additional steps are required after you install Cognos 8 before you can configure it. You must set up the database client on every computer where Content Manager, Framework Manager, or Cognos 8 Transformer is installed. The database client supports the use of Cognos 8 packages and reports, as data sources, in Framework Manager and Cognos 8 Transformer. To set up the database client, perform the following steps.
| Database | Additional Steps |
| Oracle | Set up the JDBC driver. |
| DB2 | Set up the database client software and the JDBC 2.0 driver. On UNIX, ensure that the 32-bit DB2 libraries are in the library search path, which is usually the $DB2DIR/lib directory or the $DB2DIR/lib32 directory. |
| Sybase | Set up the JDBC driver. |
| Microsoft SQL Server | No additional steps are required. The JSQLConnect.jar is installed to the appropriate location by default. |
| Cognos Content Database | No additional steps are required. |
If you use Oracle or DB2 for metric stores, you must set up the following on every computer where Application Tier Components for Metric Studio or Metric Designer are installed.
| Database | Additional Steps |
| Oracle | Set up the JDBC OCI driver. Install the SQL Loader utility. |
| DB2 | Set up the database client software and the JDBC 2.0 driver. |
| Microsoft SQL Server | The JSQLConnect.jar is installed to the appropriate location by default. You must install the bcp utility. |
If you use Oracle for your metric store, you must install the SQL Loader utility on every computer where Application Tier Components for Metric Studio or Metric Designer are installed.
If you use Microsoft SQL Server, you must install the bcp utility on every computer where Application Tier Components for Metric Studio or Metric Designer are installed.
On the computer where the Oracle client is installed, go to the ORACLE_HOME/jdbc/lib directory.
Copy the ojdbc14.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 file.
If you are using Metric Studio, copy the ojdbc14.jar file to the c8_location/webapps/p2pd/WEB-INF/lib directory on computers where Metric Studio is installed.
This file includes the driver required by the content store.
Install the DB2 client software on the appropriate computers.
If the content store is on a different computer from Content Manager, configure a database alias to the content store by running the DB2 Client Configuration Assistant.
On UNIX or Linux, use the DB2 command line interface.
If the content store database and Content Manager are on the same computer, the content store name automatically becomes the alias.
When you configure the Content Manager computers, ensure that they are all configured to use the same content store.
On Windows, stop the DB2 services and the HTML Search Server.
To copy the JDBC2 driver, copy the DB2_installation/sqllib/java/db2java.zip file to the c8_location/webapps/p2pd/WEB-INF/lib directory.
Rename the db2java.zip file to db2java.jar.
On Windows, restart the DB2 services and the HTML Search Server.
Repeat this entire procedure on the Cognos 8 computers where the software must be installed.
You can tune the database to take advantage of DB2 features. For more information, see the Architecture and Deployment Guide.
On the computer where Sybase is installed, go to the Sybase_location/jConnect-5_5/classes directory.
Copy the jconn2.jar file to the c8_location/webapps/p2pd/WEB-INF/lib directory on every computer where Content Manager is installed.
If the installation is complete, some configuration
tasks are required to ensure that Cognos 8 and Framework Manager work
in your environment.
For information about configuring Metric Designer, see Configure Metric Designer.
