IBM data server driver and client features

These tables list the features that have been delivered for each type of server and its mod pack or fix pack.

The following tables are an overview of all driver features delivered in each mod pack and fix pack. The columns are divided by type of server, while the rows are divided by type of driver. This is intended to be a high-level overview and does not provide details for each feature.

Blank cells indicate that there was no specific enhancements to highlight that is specific to the driver and server combination.

Table 1. Db2 12.1 features by mod pack
Mod Pack Level Module Feature Db2 Db2 for z/OS IBM i
12.1 ODBC/CLI New row-wise bind option when importing data with the CLI LOAD utility in CLI applications that use external tables. Yes No No
New MongoDB V6.x by IBM NoSQL/JSON Java Driver and Wire Listener. Yes No No
New parameters for workload balancing and automatic client reroute for the db2cli command. Yes Yes Yes
Enabling automatic TLS Certificate Selection. Yes Yes Yes
LOB-streaming applications uniquely identified by new process IDs in the CLI temp file name. Yes Yes Yes
Enablement of client hostname validation during TLS authentication by default. Yes Yes Yes
.Net QueryPrefetch support. Yes Yes Yes
JDBC/SQLJ Application token generation for trusted connections. Yes No No
Improved CLPPlus support for the stored procedure CALL command with unqualified stored procedure names. Yes Yes Yes
Less unnecessary network flow for automatic connection checking when an application releases its connection to a connection pool. Yes Yes Yes
Enablement of client hostname validation during TLS authentication by default. Yes Yes Yes
Support for keepAliveTimeout for later JDK versions on Windows. Yes Yes Yes
New IBM Data Server Driver for JDBC and SQLJ configuration property db2.jcc.CommandTimeout. Yes Yes Yes
Support for db2.jcc.enableSeamlessFailoverErrorCodes for connections to Db2. Yes Yes Yes
More security scenarios for encrypted user and password security. Yes Yes Yes
More IBM Data Server Driver for JDBC and SQLJ properties are supported by the db2connectactivate utility. Yes Yes Yes
New property to prevent overwriting of trace files when multiple applications that use multiple JVMs write trace data. Yes Yes Yes
New property to stop the IBM Data Server Driver for JDBC and SQLJ trace when errors or warnings occur. Yes Yes Yes
Support for the currentLockTimeout property for connections to Db2 for z/OS. No Yes No
Table 2. Db2 11.5 features by mod pack
Mod Pack Level Module Feature Db2 Db2 for z/OS IBM i
11.5.9 ODBC/CLI Enhancements to the db2cli tool now puts connection validation right in the connection string. Yes Yes Yes
Improved processing of large db2dsdriver.cfg files by the ODBC/CLI driver. Yes Yes Yes
.Net TLSVersion support. Yes Yes Yes
JDBC/SQLJ Changed default security mechanism for better security. Yes Yes Yes
SQLJ profile customizer option to control the driver action for an input data type and column data type mismatch. Yes Yes Yes
Property to control the driver action when truncation of input data occurs. Yes Yes Yes
Driver support for IBM Semeru Runtimes. Yes Yes Yes
Empty user value allowed for CP4D connections with plug-in security. Yes Yes Yes
Driver certification for more platforms. Yes Yes Yes
11.5.8 ODBC/CLI BOOLEAN support for Db2 for IBM i (V7R5). No No Yes
Mapping of Seamless Failover error codes to a communication error. Yes Yes Yes
New connection property for enhanced query performance. Yes Yes Yes
Improved control when loading IBM Global Security Kit (GSKit) libraries from a Db2 application. Yes Yes Yes
JDBC/SQLJ New tool for validating JCC properties in the db2dsdriver.cfg file. Yes Yes Yes
BOOLEAN support for Db2 for IBM i (V7R5). No No Yes
JDK 17 run time support. Yes Yes Yes
Mapping of non-seamless errors to a communication error. No Yes No
New connection property for enhanced query performance. Yes Yes Yes
New option for multi-factor authentication when using the db2connectactivate utility. Yes Yes Yes
11.5.7 ODBC/CLI Increased limit on FET_BUF_SIZE value to improve performance. Yes Yes Yes
JDBC/SQLJ Improved query fetch performance by increasing queryDataSize value. Yes Yes Yes
T4 XA support with Multi Transport model with multiple process. Yes No No
11.5.6 ODBC/CLI Improved performance when prefetching data from large data sets Yes Yes Yes
Transport Layer Security (TLS, formerly SSL) version now set at the Db2 non-java client through the db2dsdriver.cfg file and connection string Yes Yes No
Improved performance of Anonymous block execution flow for embedded SQL applications Yes Yes Yes
Support for db2cli validate -all command for user level db2dsdriver.cfg file Yes Yes Yes
Simplified process for TLS connections to Db2 databases from embedded SQL applications Yes Yes Yes
Application-specific db2locale setting now available Yes Yes Yes
Hostname validation now available for Db2 clients Yes Yes Yes
JDBC/SQLJ Improved performance when prefetching data from large data sets. Yes Yes Yes
Remote logging using Elastic Search. Yes Yes Yes
Sysplex workload balancing now enabled through the global properties file. Yes Yes No
Ability to configure driver to check for client-side Db2 license first. No Yes Yes
Support for the db2JccConfiguration.properties file in db2connectactivate operation. No Yes Yes
Connection pooling feature now available. Yes Yes Yes
Hostname validation now available for Db2 clients. Yes Yes No
11.5.5 .Net Support for Entity Framework 6.1 Yes Yes Yes
JDBC/SQLJ JDBC 4.3 specification API support. Yes Yes Yes
OpenJDK 13 runtime support. Yes Yes Yes
Odata enhancement. Yes No No
11.5.4 ODBC/CLI Support LOBFileThreshold connection string keyword through a SQLSetConnAttr. Yes Yes Yes
Capability to enable/disable db2trc using db2dsdriver.cfg configuration file. Yes Yes Yes
ODBC/CLI trace header updated to reflect the hostname/IP Address of system on which the application is running. Yes Yes Yes
New db2dsdriver.cfg keyword EnableET for instance-based ODBC/CLI driver. Yes No No
Support db2dsdriver.cfg for User Level DSN in Microsoft ODBC Data Source Administrator GUI. Yes Yes Yes
JSON Web Token Support for Authentication. Yes No No
IBM® Db2Nosql/JSON Wire Listener Enhancement. Yes Yes No
.Net Code first support for Db2 for z/OS®. Yes Yes No
.NET Core driver on Microsoft Azure. Yes Yes Yes
Leverage new features of .NET core 2.1. Yes Yes Yes
.NET Core Driver support for Microsoft Windows Nano Server. Yes Yes Yes
Support for .NET Core 3.1. Yes Yes Yes
Db2 .NET Core support on AWS. Yes Yes Yes
JDBC/SQLJ CLPPlus new command line keyword support using connection identifier. Yes No No
JDBC 4.2 specification support. Yes Yes Yes
OpenJDK 11 run time support. Yes Yes Yes
Preserve Statement cache at XA Rollback/Commit. No Yes No
JCC support with IDAA and t2zos connectivity. No Yes No
JSON Web Token support. Yes No No
New open source tool for better Spring Application configuration. Yes Yes Yes
11.5 GA ODBC/CLI Data movement using cliload with an External Table. Yes No No
Unique utility id generation for zload. No Yes No
db2dsdriver.cfg support in MS ODBC Administrator. Yes Yes Yes
Enhancement to the WLB/ACR algorithm. No Yes No
Server side enablement of WLB/ACR for Db2 pureScale server. Yes No No
.Net Db2 .Net EF Core support. Yes Yes Yes
Microsoft Entity Framework 2.1 support. Yes Yes Yes
IBM Data Server Driver for ADO.Net support. Yes Yes Yes
Visual Studio Code Extension for Db2. Yes Yes Yes
JDBC/SQLJ Server side enablement of WLB/ACR for Db2 pureScale server. Yes No No
clientApplcompat enhancements. No Yes No
Change to the default behavior of the timerLevelForQueryTimeOut property. Yes Yes Yes
Support for named parameter markers with (var1=>?,var2=>?,...) syntax added in java.sql.CallableStatement for Db2 for z/OS. Yes Yes No
Table 3. Db2 11.1 features by mod pack and fix pack
Mod Pack or Fix Pack Level Module All Servers Db2 Db2 for z/OS Informix IBM i
11.1 GA ODBC
  • Mapping of NZ connection string keywords to CLI connection string keywords
  • Mapping of NZ environment connection and statement attributes
  • Option to query metadata in Uppercase in APIs like SQLTables
  • Attribute to efficiently set global variables
  • Support Timestamps for CLI trace captured through db2trc tool
  • Support Tracecomm for CLI trace captured through db2trc tool
  • Serviceability Improvements to db2trc tool and db2DumpSQL Codes CLI configuration keyword
  • Passive Connect: Connect without activating the database
  • Reduce cost of failback
    
Db2.NET
  • Entity Framework 6.1 support (Connection Resiliency feature)
  • DB2DataReader support for new .NET 4.5 async methods
  • Access to CA to reutrn DBMS indicator
  • LDAP settings in global area of db2dsdriver.cfg
  
  • Ability to specify registry for trusted context
  • Serviceability enhancements (two new keywords Db2DumpSQLCodes, Db2DumpSQLCodesInterval are added)
  
  • Timestamp precision (in the range of 0 to 12) for Db2 for IBM i 7R2 or later
  • LibraryList Connection string keyword support
Visual Studio
  • Entity Framework 6.1 support
  • Visual Studio 2015 support
  • Visual Studio 2017 support
      
  • Timestamp precision (in the range of 0 to 12) for Db2 for IBM i 7R2 or later
  • Support regex in SQL (from Db2 for IBM i 7R1 or later)
JCC
  • NZ compatibility through support for Netezza connection URL, NZData-Source and selected NZ connection properties
  • Specification of cipher suites for SSL connections
  • BiDi layout transformation
  • Serviceability improvments - online tracing, SQLCODE configuration for automated dump generation
  • db2sqljcustomize enhancement to accept a new hostlang option
  
  • Use RACF keyring based stores for SSL Certificates
    
11.1.1.1 ODBC
  • External table support by ODBC/CLI
  • In-memory default keystore database for SSL connection
  • Dynamic enabling/disabling of serviceability log
  • Blocking support for scrollable cursors for lobs and non-lobs
  • Register ODBC DSN with description
  • GUI support in Microsoft ODBC Data Source Administrator for DSN creation
  • New function level support for continuous delivery
  
  • Support for Db2 for IBM i 7R3
Db2.NET    
  • Serviceability improvements to db2DumpSQLCodes configuration keyword
  • Dynamic enabling or disabling of serviceability log
  • New function level support for continuous delivery and PKGNAMCT support
  
  • Support for Db2 for IBM i 7R3
Visual Studio      
  • Support for Db2 for IBM i 7R3
JCC
  • Encrypted user ID and password on SERVER_ENCRYPT
  
  • Client certificate selection from trust store using certificate keyUsage property
  • Preserve statement cache at rollback
  • DRDA FAST LOAD
  • New function level support for continuous delivery
  
  • Support for Db2 for IBM i 7R3