Setting up connectivity to Db2 data sources

To connect to DB2® data sources, the dynamic query mode requires access to the IBM® Db2 type 4 JDBC driver and its appropriate license file.

About this task

Because Type 4 driver is an independent product, you are not required to install the Db2 software. That is, you are not required to install the Db2 client on the computer where you installed Content Manager.

For the Type 4 JDBC connectivity, you must copy the universal driver and the accompanying license file to your IBM Cognos® installation location.

Procedure

  1. On the Windows operating system, stop the Db2 services and the HTML Search Server.
  2. In the IBM DB2 installation directory of the database that you want to use for the connection, locate the ..\SQLIB\JAVA directory.
  3. Copy the following files to the cognos_analytics_server_install_location\drivers directory.
    • Universal driver file, db2jcc.jar
    • License files, based on the IBM Db2 platform
      • Db2 on Linux®, UNIX, or Windows, db2jcc_license_cu.jar
      • Db2 on z/OS®, db2jcc_license_cisuz.jar
  4. On Windows, restart the Db2 services and the HTML Search Server.
  5. Stop and then restart the IBM Cognos service.

What to do next

After you copy the driver files for your data source, users can create dynamic cubes. For more information, see the Dynamic cube modeling chapter of the IBM Cognos Dynamic Cubes User Guide.