DB2 Version 10.1 for Linux, UNIX, and Windows

Call level interface (CLI) driver enhancements

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

Review the technical changes and new functionality that are included in the following Version 10.1 fix packs. Each fix pack for a release is cumulative: it contains all the technical changes and new functionality that were included in previous fix packs for that release.

FP2: Enhancements to the DB2 interactive CLI command (db2cli)

Version 10.1 Fix Pack 2 and later fix packs include the following enhancements to the db2cli command:

FP2: Support for testing database connectivity with the IBM Data Server Driver Package software and the db2dsdriver.cfg file

In Version 10.1 Fix Pack 2 and later fix packs, the IBM® Data Server Driver Package software can test database connectivity:

FP2: Support for the special characters in a password

In Version 10.1 Fix Pack 2 and later fix packs, the CLI driver accepts special characters in the password, with some exceptions. See Password rules for drivers and CLPPlus.

FP2: New attributes

Version 10.1 Fix Pack 2 and later fix packs include the following new attributes:
  • You can set the SQL_FREE_MEMORY_ON_STMTCLOSE_YES and SQL_FREE_MEMORY_ON_STMTCLOSE_NO attributes at the statement and connection level to free memory on the client when you specify the SQL_CLOSE action. See Connection attributes (CLI) list.
  • You can set the SQL_ATTR_DBC_SYS_NAMING_YES and SQL_ATTR_DBC_SYS_NAMING_NO connection attributes to enable and disable the SQL naming mode on the DB2 for i server. See Connection attributes (CLI) list.
  • You can set the SQL_ATTR_DB2TRC_STARTUP_SIZE environment attribute to specify the DB2 trace buffer size on all platforms. See Environment attributes (CLI) list.

FP2: Enhancements to the db2dsdriver.cfg file

Version 10.1 Fix Pack 2 and later fix packs include the following enhancements to the db2dsdriver.cfg file:

FP2: Enhancement to the SQLDataSources() API

In Version 10.1 Fix Pack 2 and later fix packs, the SQLDataSources() API can return data source names (DSN) from the database directory and the db2dsdriver.cfg file. See SQLDataSources function (CLI) - Get list of data sources.

FP1: Enhancements to the DB2 interactive CLI command (db2cli) (Windows)

Version 10.1 Fix Pack 1 and later fix packs include the following enhancements to the db2cli command:
  • You can issue the db2cli validate command to obtain a complete list of IBM data server client packages that are installed on a Windows operating system. When you issue the command on a Windows operating system, the db2cli command reports all duplicate and conflicting settings for the same property in the same DSN, database, or global section of the db2dsdriver.cfg file.
  • You can issue the db2cli validate command to check duplicate or conflicting keyword entries in the same section of the db2dsdriver.cfg file.
  • On Windows operating systems, new options are added to the registerdsn parameter for the db2cli command:
    • The db2cli registerdsn -remove command include the following new options:
      • -alldsn
      • -copyname copy_name
      • -allcopies
      • -force
      • -dsn
    • The db2cli registerdsn -add command includes the new -dsn option.
    • The db2cli registerdsn -list command includes the following new options:
      • -copyname copy_name
      • -allcopies
    See db2cli - DB2 interactive CLI command .

FP1: Support for DB2 for i servers has been further enhanced

In Version 10.1 Fix Pack 1 and later fix packs, CLI applications support the following features in DB2 for i servers:

FP1: SQL_ATTR_NETWORK_STATISTICS attribute support has been further enhanced

In Version 10.1 Fix Pack 1 and later fix packs, you can obtain the server time for COMMIT or ROLLBACK SQL operations on DB2 for z/OS® Version 10 and later. SeeConnection attributes (CLI) list.

FP1: New LDAP keywords for the db2dsdriver.cfg file

In Version 10.1 Fix Pack 1 and later fix packs, the following new keywords are added to the db2dsdriver.cfg for the LDAP support:
  • EnableLDAP
  • LDAPServerHost
  • LDAPServerport
  • ClientProvider
  • BaseDN
  • UserID
  • Password
See IBM Data Server Driver configuration keywords.

FP1: New SQL_C_CURSORHANDLE C data type

In Version 10.1 Fix Pack 1 and later fix packs, the new SQL_C_CURSORHANDLE C data type is available for use with the SQL_CURSORHANDLE SQL data type. See SQL symbolic and default data types for CLI applications.

FP1: QueryTimeout keyword support

In Version 10.1 Fix Pack 1 and later fix packs, the CLI driver now supports use of the QueryTimeout keyword in the db2dsdriver.cfg file. See QueryTimeout IBM Data Server Driver configuration keyword.

FP1: Prefetched cursor support for seamless automatic client reroute

In Version 10.1 Fix Pack 1 and later fix packs, if all the data, including the end of file (EOF) character, is returned in the first query block or in a subsequent fetch request, the CLI driver can perform seamless failover when you issue a COMMIT or ROLLBACK statement after the server becomes unreachable. For seamless failover to take place, the following conditions must be met:
  • You must enable both the enableAcr and enableSeamlessAcr parameters.
  • The cursor must have blocking enabled.
  • The cursor must be either read only or forward only.
See Operation of automatic client reroute for connections to DB2 Database for Linux, UNIX, and Windows from non-Java clients, Operation of automatic client reroute for connections from non-Java clients to DB2 for z/OS servers, and Operation of automatic client reroute for connections to Informix® database server from non-Java clients.