IBM Support

Cognos BI support for DB2 i JDBC

Product documentation


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.


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 Use one of the required versions of the driver (such as 8.1) and use the JAR files with in the file name. For example, when downloading 8.1, download

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.

Document information

More support for: Cognos Business Intelligence

Software version: 10.2.1

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Reference #: 7042338

Modified date: 20 June 2014