IBM Data Server Driver for JDBC and SQLJ enhancements

The IBM Data Server Driver for JDBC and SQLJ contains security and usability enhancements for the Db2 12.1.4 release.

Db2 12.1.4 enhancements

Table 1. IBM Data Server Driver for JDBC and SQLJ enhancements and new capabilities in 12.1.4
Enhancement Description
Enhancements to copying content from the CLPPlus utility in Window mode. In Db2 12.1.3 and earlier, the CLPPlus utility does not allow users to copy connection information, the SQL command being run, and the output from the command in a single operation. Users can only copy the query or the result set separately. This limitation is an issue for users when they need to share, document, or analyze the query and the results together, as users are forced to copy-paste multiple times, which increases the risk of missing information and errors and reduces productivity.
With the release of Db2 12.1.4, users can now select and copy both the SQL commands and the corresponding output together in a single action. While user input and the generated output are highlighted, the full content of the console window is copied and pasted.
Support for Java Runtime Engine (JRE) 25. The IBM Data Server Driver for JDBC and SQLJ now supports the Java runtime environment that is provided with version 25 of both the SDK for Java and the JDK. For Db2 12.1.4, the minimum required JRE version is JRE 1.8.
New global property to control whether files generated by the JDBC driver are world-readable. Some files are created by the IBM Data Server Driver for JDBC and SQLJ:
  • The trial license
  • The data file
  • JCC dump logs
  • Trace logs
  • tltmp.bin
To address security concerns, a new global property, db2.jcc.enableWorldReadable, specifies whether the files that are generated by the JDBC/SQLJ driver for Db2 on Linux and UNIX have world-readable permissions.

The default setting is TRUE for connections.

This property is not applicable for Db2 12.1.4 on Windows.

For more information, see the description for db2.jcc.enableWorldReadable in IBM Data Server Driver for JDBC and SQLJ configuration properties