IBM Support

Cognos BI support for DB2 i JDBC

Product Documentation


Abstract

IBM Cognos Business Intelligence 10.2.1 Fix Pack 3 adds support for the IBM JT400 JDBC drivers.

This documents outlines details related to this.

Content

Database connections that are defined as type DB2 use the IBM JCC JDBC driver. In order to use JT400, use the generic JDBC connection and select IBM DB2 iSeries via IBM Toolbox for Java in the list.


Drivers downloaded from SourceForge

IBM makes the JDBC driver available from Sourceforge http://sourceforge.net/projects/jt400/files/JTOpen-full/. Use one of the required versions of the driver (such as 8.1) and use the JAR files with jdbc40_jdk6.zip in the file name. For example, when downloading 8.1, download jtopen_8_1_jdbc40_jdk6.zip.


Connection properties

A new connection shows example connection properties that are passed to the JDBC driver. The connection properties control how the JDBC driver presents dates, times, and decimal separators independent of the DB2 server settings. For more details on DB2 iSeries JDBC connection properties, refer to the IBM Toolbox for Java JDBC properties documentation in the iSeries Information Center.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.2.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 June 2018

UID

swg27042338