Set up database connectivity for an IBM® Db2 content store

Download and copy a supported Db2 JDBC driver to each computer where Content Manager is installed.

You must use a type 4 Java Database Connectivity (JDBC) driver to connect to your content store. The type 4 driver is considered an independent product. It does not require the Db2® client to be installed.

Procedure

Copy the following files from Db2_installation\sqllib\java directory to the Cognos® Analytics install_location\drivers directory:
  • The universal driver file: db2jcc4.jar
  • The license file:

    For Db2 on Linux®, UNIX, or Windows operating systems, use db2jcc_license_cu.jar.

    For Db2 on z/OS®, use db2jcc_license_cisuz.jar.

    If you are connecting to Db2 on z/OS, use the driver version from Linux, UNIX, or Windows version 9.1 fix pack 5 or version 9.5 fix pack 2.

    Tip: To check the driver version, run the following command:
    java -cp path\db2jcc4.jar com.ibm.db2.jcc.DB2Jcc -version