The IBM Data Server Driver for JDBC and SQLJ

When a Java™ application for CICS® makes JDBC and SQLJ requests of either type 2 connectivity or type 4 connectivity to an IBM® DB2® for z/OS® database, the requests are processed by the IBM Data Server Driver for JDBC and SQLJ.

In a CICS environment using type 2 connectivity, the IBM Data Server Driver for JDBC and SQLJ converts the JDBC or SQLJ requests into their EXEC SQL equivalents. The converted requests from the DB2-supplied JDBC driver flow into the CICS DB2 attachment facility in exactly the same way as EXEC SQL requests from any other program (for example, a COBOL program). There are no operational differences between Java programs for CICS DB2 and other programs for CICS DB2, and all customization and tuning options available using RDO apply to Java programs for CICS DB2.

Note: When using type 2 connectivity, Db2 client information such as the ClientUser and ClientHostName values are ignored by CICS Db2 attach. They are not supported.

To use the IBM Data Server Driver for JDBC and SQLJ with CICS, you must be connected to a DB2 subsystem that supports the appropriate level of your driver version. Only type 2 connectivity uses the CICS DB2 connection resource.

In addition to type 2 connectivity, a Liberty JVM server also supports type 4 connectivity, which does not require the CICS DB2 connection resource.

Full details of how to code and build Java applications that use the JDBC and SQLJ application programming interfaces can be found in the DB2 for z/OS: Programming for Java that applies to your version of DB2.