Call level interface (CLI) driver enhancements
The CLI driver contains performance and usability enhancements for the Db2 12.1 mod pack release.
Attention: The Db2 12.1 release is currently available for the
following Db2 products:
- Db2 Distributed (on-premises)
- The container micro-service deployments of Db2 and Db2 Warehouse for Kubernetes-based clusters, which includes Red Hat OpenShift, the Amazon Elastic Kubernetes Service (EKS), the Red Hat OpenShift Service on AWS (ROSA), and the Azure Kubernetes Service (AKS).
Db2 12.1 enhancements
The Db2 12.1
release includes the following enhancements and new capabilities for the CLI driver:
| Enhancement | Description |
|---|---|
| New row-wise bind option when importing data with the CLI LOAD utility in CLI applications that use external tables. | Db2 CLI applications that use the CLI LOAD utility bind parameter markers with column-wise array input when importing external tables in binary format. Db2 12.1 now enables you to choose row-wise array input for the same operation. |
| New MongoDB V6.x by IBM NoSQL/JSON Java Driver and Wire Listener. | Db2
provides a Java™ API, a command-line interface, and a wire listener feature to manage and query JSON
documents that are stored in a Db2 database by using a JSON-oriented query language.
With the release of Db2 12.1, the MongoDB 6.x APIs are now supported by the Db2 NoSQL/JSON Java Driver and the Wire Listener. These additions allow you to interact with JSON data by using the most recent APIs and provides write operations needed for Create, Read, Update, and Delete (CRUD) operations. |
| New parameters for workload balancing and automatic client reroute for the db2cli command. | The db2cli writecfg command provides the means to update the
db2dsdriver.cfg configuration file. Prior to Db2 12.1, adding sections
for workload balancing (WLB) and automatic client reroute (ACR) had to be done by manually editing
the configuration file. With this release, add and remove parameters are available for both
-acr and -wlb operations through the db2cli
writecfg command. |
| Db2 Connect licence information now propagated to Db2 for z/OS® servers. | You can now determine the license information of a Db2 Connect connection to a
Db2 for z/OS server by
looking at certain field values in the IFCID 417 distributed data facility (DDF)
trace record. For more information, see Auditing Db2 Connect client and driver licenses at the Db2 for z/OS server |
| Enabling automatic TLS Certificate Selection. |
You can omit setting the If your keystore, or MSCS, has more than one personal certificate or more than one key entry, and
the |
| LOB-streaming applications uniquely identified by new process IDs in the CLI temp file name. | With the release of Db2 12.1, a new process
ID and thread ID are added to the temporary file names created for each
SQL_DATA_AT_EXEC parameter. These temp files are created during
SQLPutData operations for DATA_AT_EXEC parameters for LOB input data.
Under normal operations, these temp files are removed by the Data Server Driver after the
SQLPutData operation is done. If the application you are running goes down, these
temp files can be left behind before the driver can delete them. By adding process and thread information to the file names of these temp files, you are better able to identify the files that are safe to remove from your system. |
| Enablement of client hostname validation during TLS authentication by default. | To provide better security during a connection to Db2 data server that uses
using transport layer security (TLS), the default value of the
sslClientHostnameValidation property is changed from OFF to BASIC. |
| Availability of ARM 64 bit driver binary for MAC M1/M2/M3 machines. | ARM driver binaries are now available for MAC. You can now use Db2 12.1 driver binaries
for ARM chip set machines (M1/M2/M3) and Db2 11.5 driver binaries for INTEL chip set machines. For more information, see Installing the IBM Data Server Driver Package software on Mac OS X |