IBM Data Server Driver for JDBC and SQLJ enhancements for Db2 11.5.7
The IBM Data Server Driver for JDBC and SQLJ contains a number of major enhancements for the Db2 11.5.7 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.
Attention: This mod pack release is currently available for
the following Db2 products:
- Db2 on-premises
- The single container deployments of Db2 Warehouse and IBM Integrated Analytics System (IIAS).
- The container micro-service deployment of Db2 on Red Hat OpenShift.
11.5.7 enhancements
| Enhancement | Description |
|---|---|
| Improved query fetch performance by increasing queryDataSize value | The queryDataSize value of the JCC driver is used to optimize Db2
applications by controlling the number of trips to a data source that are needed to retrieve
data. With the release of Db2 11.5.7, the maximum value of the queryDataSize is increased to 10 MB from the previous limit of 256 KB. This increase drastically reduces the number of trips needed to retrieve data, and improves performance on slower networks and those with larger distances from client to server. |
| T4 XA support with Multi Transport model with multiple process | For transactional databases using extended architecture (XA), Db2 supports multiple
transports from multiple application processes during the same transaction. This is referred to as
the Multi Transport model. With the release of Db2 11.5.7, two Db2 JCC driver properties are used to set whether the XA transactions follow the dual transport mode using different process. For more information see the properties db2.jcc.enableDualTransportUsingDifferentProcess and db2.jcc.override.enableDualTransportUsingDifferentProcess in IBM Data Server Driver for JDBC and SQLJ configuration properties |