IBM Data Server Driver for JDBC and SQLJ enhancements

Version 4.27 contains functions from Version 4.0 or later. The db2jcc.jar (JCC 3 driver based on JDBC 3 specification) has not been shipped. The last version shipped is 3.72.54 which is delivered with Db2 Version 11.1 Mod Pack 4 and Fix Pack 5.

Attention: The enhancements in this topic are included in the Db2 11.5.4 mod pack release, which is available for the following products:

11.5.4 enhancements

The Db2 11.5.4 release includes the following enhancements and new capabilities for the IBM Data Server Driver for JDBC and SQLJ:
Table 1. IBM Data Server Driver for JDBC and SQLJ enhancements and new capabilities in 11.5.4
Enhancement Description
CLPPlus new command line keyword support using connection identifier CLPPlus now supports setting AUTHENTICATION, securityTransportMode, and sslCertLocation through the command line (using clause).
JDBC 4.2 specification support JCC driver is now compliant with JDBC 4.2 specification.
OpenJDK 11 run time support JCC driver now supports OpenJDK 11 as the runtime environment for the application migration. Applications using JCC can migrate to OpenJDK 11.
Preserve Statement cache at XA Rollback/Commit JCC preserves statements across XA Commit and XA Rollback when connected to Db2 for z/OS® V12 with PTF UI65514. This improves the performance for XA applications. This change in behavior will be transparent to the application.
JCC support with IDAA and t2zos connectivity If enableT2zosLBF is true LBF is ON in case of a LOCAL cursor. When IDAA is ON during run time, the remote cursor is activated and LBF is turned to false in the server. To achieve this, a new global property (db2.jcc.enableT2zosLBFSwitchWithIDAA=1) has been added, which will inform the JCC driver that IDAA will be enabled during run time. Based on this property, JCC will allocate and send two types of memory to handle a local and remote cursor to the Db2 server.
JSON Web Token support. JCC supports a new authentication mechanism using JSON web tokens for Db2. JCC provides necessary APIs to pass JSON web tokens supplied by the application, along with other necessary details to the server.
New Opensource tool for better Spring Application configuration Below is a library to provide Spring developers easy configuration of the official Db2 library for Java. Visit these pages for more information: