Cognos BI support for DB2 i JDBC
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 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.
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.