IBM Data Server Driver for JDBC and SQLJ enhancements

The IBM Data Server Driver for JDBC and SQLJ contains a number of major enhancements for the Db2 11.5 base product, its mod packs, and its fix packs. Each fix pack for a release is cumulative; that is, a particular fix pack contains the enhancements and new features that were included in previous fix packs.

11.5 enhancements

Version 4.26 contains functions from Version 4.0 or later. The db2jcc.jar (JCC 3 driver based on JDBC 3 specification) is not shipped. The last version shipped is 3.72.54 which is delivered with Db2 11.1 Mod Pack 4 and Fix Pack 5.
Table 1. IBM Data Server Driver for JDBC and SQLJ enhancements and new capabilities in 11.5
Enhancement Description
Server side enablement of WLB/ACR for Db2 pureScale server WLB/ACR can be triggered by setting the Member subset attribute in the server.
clientApplcompat enhancements Various enhancements are added to the driver to simplify the usage of clientApplcompat:
  • Command line input option in db2connectactivate tool for clientApplcompat
  • Read clientApplcompat and currentPackageSet value through db2dsdriver.cfg file in CLPPlus
  • Support clientApplcompat and currentPackageSet value through the db2dsdriver.cfg file
Change to the default behavior of the timerLevelForQueryTimeOut property The default behavior of the timeLevelForQueryTimeOut property is changed to QUERYTIMEOUT_CONNECTION_LEVEL(2). This change of the default timer level for query timeout from Statement to Connection improves performance.
Support for named parameter markers with (var1=>?,var2=>?,...) syntax added in java.sql.CallableStatement for Db2 for z/OS java.sql.CallableStatement supports (var1=>?,var2=>?,...) syntax for Db2 for z/OS. It is already supported for Db2 LUW.