DB2 10.5 for Linux, UNIX, and Windows

Call level interface (CLI) driver enhancements

The CLI driver contains a number of major enhancements for Version 10.5.

Review the technical changes and new features that are included in the following Version 10.5 and its fix packs. Each fix pack for a release is cumulative.

DB2® Version 10.5 Fix Pack 5 enhancements
DB2 Cancun Release 10.5.0.4 enhancements
Fix Pack 2 enhancements
Version 10.5 enhancements

DB2 V10.5 FP5: General enhancements to the CLI driver

The DB2 Version 10.5 Fix Pack 5 product includes the following enhancements to the CLI driver.

You can now establish SSL connections to a database server by setting the Security CLI keyword or the SecurityTransportMode IBM® data server driver configuration keyword to SSL without separately installing and configuring the GSkit product. See SecurityTransportMode IBM data server driver configuration keyword.
You can now establish SSL connection using a self-signed certificate or a certificate authority (CA) certificate by setting the SSLServerCertificate keyword. By setting the SSLServerCertificate keyword, you avoid having to set the SSLClientKeystoredb keyword with the SSLClientKeystoreDBPassword or SSLClientKeyStash keyword. See SSLServerCertificate IBM data server driver configuration keyword.
You can now issue the db2dsdcfgfill command to read in the LDAP database entries in the local database directory and create the IBM data server driver configuration file. See db2dsdcfgfill - Create configuration file db2dsdriver.cfg

DB2 V10.5 FP5: The CLI driver enhancements for connection to DB2 for z/OS servers

The DB2 Version 10.5 Fix Pack 5 product includes the following enhancements to the CLI driver that are specific for connections to DB2 for z/OS® servers:

You can now retrieve the default client information register values that are set on the DB2 for z/OS server by setting the enableDefaultClientInfo IBM data server driver configuration keyword to True. See enableDefaultClientInfo IBM data server driver configuration keyword.
You can now retrieve the extended table information about the IBM DB2 Analytics Accelerator for IBM z/OS (IDAA) table by setting the ExtendedTableInfo keyword to True. See ExtendedTableInfo IBM data server driver configuration keyword.
You can now obtain additional diagnostic logs when a selected SQLCODE is first encountered in a connection to the DB2 for z/OS server with the db2dumpSQLCodes IBM data server driver configuration keyword. See db2dumpSQLCodes IBM data server driver configuration keyword.

DB2 Cancun Release: The CLI driver enhancements to the seamless failover feature

The DB2 Cancun Release 10.5.0.4 product includes the following enhancements to the seamless failover feature:

You can now specify the SQL_ATTR_REPORT_SEAMLESSFAILOVER_WARNING connection attribute to determine whether to return a warning message when a connection fails over seamlessly. See Connection attributes (CLI) list.
You can now specify the detectReadonlyTxn keyword to modify the seamless failover feature when you are connecting to the following servers:
- DB2 for Linux, UNIX, and Windows Cancun Release and later fix packs.
- DB2 for z/OS Version 11 in new function mode (NFM) with the automatic client reroute and Sysplex workload balancing features enabled.
See Configuration of Sysplex workload balancing and automatic client reroute for applications other than Java™.

DB2 Cancun Release: The CLI driver enhancements for connection to DB2 for i servers

The DB2 Cancun Release 10.5.0.4 product includes the following enhancements to the CLI driver that are specific for connections to DB2 for i V7R1 and later servers:

You can now specify array parameters when you are calling a stored procedure with array input arguments on DB2 for i V7R1 and later servers. See Calling stored procedures with array parameters from CLI applications.
The global variables in the IBM data server driver configuration file are supported by the CLI driver for use with DB2 for i V7R1 and later servers. See IBM data server driver configuration file structure.
The CLI driver now supports the SQL_ATTR_CONCURRENT_ACCESS_RESOLUTION connection attribute and the ConcurrentAccessResolution keyword for use with DB2 for i V7R1 and later servers. See Connection attributes (CLI) list.

DB2 Cancun Release: The CLI driver enhancements for connection to DB2 for z/OS servers

You can now specify the SQL_ATTR_COLUMNWISE_MRI attribute and the ColumnwiseMRI keyword for the MERGE statements to enable array input chaining.

DB2 Cancun Release: General enhancements to the CLI driver

The DB2 Cancun Release 10.5.0.4 product includes the following enhancements to the CLI driver.

You can now specify the GRANT and GRANT_ROLE bind options with the SQLCreatePkg() function. See SQLCreatePkg().
You can now specify the GRANT and GRANT_ROLE bind options with the db2cli command. See db2cli - DB2 interactive CLI command.
You can now specify the SQL_AUTOCOMMIT_DEFERRED value for the SQL_ATTR_AUTOCOMMIT connection attribute. See Connection attributes (CLI) list.
The CLI metadata functions now support CODEUNITS32 columns.
- SQLColAttribute(): See SQLColAttribute().
- SQLColumns(): See SQLColumns().
- SQLExtendedProcedureColumns(): See SQLExtendedProcedureColumns().
- SQLProcedureColumns(): See SQLProcedureColumns().
- SQLSpecialColumns(): See SQLSpecialColumns().
You can now specify the 'NODEFAULT' value for the ClientWrkStnName or ClientWorkstationName keyword to prevent a domain name server (DNS) lookup when the client workstation value is not required. See ClientWorkstationName IBM data server driver configuration keyword and ClientWrkStnName CLI/ODBC configuration keyword.
You can now obtain a list of all configuration keywords that are set on the server by calling the SQLGetInfo() function with the new SQL_CONFIG_KEYWORDS argument. See SQLGetInfo function .
The CLI driver can now retry running the MERGE statement up to six times when the SQL_ATTR_RETRY_ON_MERGE attribute or the RetryOnMERGE keyword is set.
You can now specify a read-only connection with the SQL_ATTR_READ_ONLY_CONNECTION connection attribute or the ReadOnlyConnection keyword.

FP2: The CLI driver enhancements for connection to DB2 for z/OS servers

The Version 10.5 Fix Pack 2 product includes the following enhancements to the CLI driver that are specific for connections to DB2 for z/OS servers:

You can now specify array parameters when you are calling a stored procedure with array input arguments on DB2 for z/OS Version 11 servers in new function mode (NFM). See Calling stored procedures with array parameters from CLI applications.
The CLI driver implements the implicit COMMIT operation when the application calls a stored procedure on a DB2 for z/OS server. By implicitly implementing the COMMIT operation on DB2 for z/OS server, extra network flow to the server is avoided. The following conditions must be met for the implicit COMMIT behavior:
- The connected database server is DB2 for z/OS Version 11 servers in new function mode (NFM).
- Entire result-set that is returned from the stored procedure is contained within the single query block. The query block size can be adjusted with the FET_BUF_SIZE db2cli.ini keyword or the FetchBufferSize IBM data server driver configuration keyword.
See Calling stored procedures from CLI applications.
You can now specify the Client Correlation Token information when you are connecting to DB2 for z/OS Version 11 servers in new function mode (NFM). Specify the Client Correlation Token information by using one of the following methods:
- Setting the SQL_ATTR_INFO_CRRTKN environment attribute.
- Setting the SQL_ATTR_INFO_CRRTKN connection attribute.
- Setting the ClientCorrelationToken IBM data server driver configuration keyword.
- Setting the ClientCorrelationToken db2cli.ini keyword.
See Connection attributes (CLI) list and Environment attributes (CLI) list.
The default value of the CommitOnEOF keyword and the SQL_ATTR_COMMITONEOF connection attribute is TRUE only when you are connecting to DB2 for z/OS Version 9 and later servers. See Connection attributes (CLI) list.
The global variables in the IBM data server driver configuration file are supported by the CLI driver for use in connection to DB2 for z/OS Version 11 servers in new function mode (NFM). When you are connecting to the supported DB2 for z/OS servers, the CURRENT APPLICATION COMPATIBILITY special register must be set to the V11R1 value. See IBM data server driver configuration file structure.

FP2: General enhancements to the CLI driver

The Fix Pack 2 product includes the following enhancements to the CLI driver.

You can now specify the SQL_DESC_IDENTITY_VALUE parameter with the SQLGetDescField() or SQLColAttribute() function to determine whether a column is an identity column or not. See Descriptor header and record field initialization values (CLI).
You can now specify the following bind options with the SQLCreatePkg() function:
- GENERIC
- MSGFILE
- RELEASE
See SQLCreatePkg().
You can now specify the RetryParameterBindingOnError keyword in the IBM data server driver configuration file (db2dsdriver.cfg). The CLI driver also supports the RetryParameterBindingOnError keyword in the db2cli.ini file. See RetryParameterBindingOnError IBM data server driver configuration keyword and RetryParameterBindingOnError CLI/ODBC configuration keyword.

Version 10.5: The CLI driver enhancements for the DB2 High Availability feature

You can now use the SQL_ATTR_OVERRIDE_PRIMARY_AFFINITY connection attribute to specify a new temporary primary member for the client affinities feature without modifying the IBM data server driver configuration file (db2dsdriver.cfg). See Connection attributes (CLI) list.

Version 10.5: The CLI driver enhancements for calling stored procedures

The Version 10.5 CLI driver includes the following enhancements for calling a stored procedure:

You can now specify the SQL_ATTR_STREAM_OUTPUTLOB_ON_CALL attribute on a connection or statement level to stream a stored procedure OUT parameter data that is a LOB or an XML data type. See Connection attributes (CLI) list and Statement attributes (CLI) list.
You can now issue the batch CALL statement to optimize the network flow when you are calling a stored procedure. To enable the batch CALL statement support, CLI applications must specify array size with the SQL_ATTR_PARAMSET_SIZE statement attribute and provide argument data in form of an array. See Calling stored procedures from CLI applications.

Version 10.5: The CLI driver enhancements for connection to DB2 for i servers

The Version 10.5 product includes the following enhancements to the CLI driver that is specific for connection to DB2 for i servers:

You can now refresh a cached value of the *USRLIBL value by using one of the following methods:
- Setting the SQL_ATTR_CACHE_USRLIBL connection attribute.
- Setting the CacheUsrLibL db2dsdriver.cfg keyword.
- Setting the CacheUsrLibL db2cli.ini keyword.
See Connection attributes (CLI) list.
You can now specify the following attributes at the environment or connection level when you are connecting to DB2 for i servers:
- SQL_ATTR_DATE_FMT
- SQL_ATTR_DATE_SEP
- SQL_ATTR_TIME_FMT
- SQL_ATTR_TIME_SEP
- SQL_ATTR_DECIMAL_SEP
See Connection attributes (CLI) list and Environment attributes (CLI) list.

Version 10.5: General enhancements to the CLI driver

The Version 10.5 product includes the following enhancements to the CLI driver.

You can now specify the session global variables in the IBM data server driver configuration file (db2dsdriver.cfg). The following conditions must be met for use of the session global variables:
- The connected database server must be supported by the CLI driver. The CLI driver supports DB2 for Linux, UNIX, and Windows servers.
- The session global variables must be specified in the <sessionglobalvariables> subsection in the IBM data server driver configuration file (db2dsdriver.cfg).
- The global variables that are referenced in the <sessionglobalvariables> subsection in the IBM data server driver configuration file (db2dsdriver.cfg) must be created on the database server before its use.
See IBM data server driver configuration file structure.
You can now specify up to 255 characters for the following IBM data server driver configuration client information keywords:
- ClientAccountingString
- ClientApplicationName
- ClientUserID
- ClientWorkstationName
See IBM data server driver configuration keywords for client information.
You can now specify up to 255 characters for the following db2cli.ini client information keywords:
- ClientAcctStr
- ClientApplName
- ClientUserID
- ClientWrkStnName
See IBM data server driver configuration keywords for client information.
You can now specify up to 255 characters for the following environment and connection attributes:
- SQL_ATTR_INFO_ACCTSTR
- SQL_ATTR_INFO_APPLNAME
- SQL_ATTR_INFO_USERID
- SQL_ATTR_INFO_WRKSTNNAME
See Connection attributes (CLI) list and Environment attributes (CLI) list.
You can now validate all database and DSN entries in the IBM data server driver configuration file (db2dsdriver.cfg) with the db2cli command. See db2cli - DB2 interactive CLI command.