Restrictions of the IBM Data Server Driver for ODBC and CLI

The IBM® Data Server Driver for ODBC and CLI is not part of the IBM Data Server Client or the IBM Data Server Runtime Client. You must install and configure it separately; and it provides a subset of the functionality of either IBM Data Server client.

IBM Data Server Driver for ODBC and CLI provides runtime support for:

  • The Db2® CLI application programming interface (API)
  • The ODBC API
  • The XA API
  • Database connectivity
  • The Db2 Interactive Call Level Interface (db2cli)
The following restrictions apply to the IBM Data Server Driver for ODBC and CLI:
  • No other database product can be installed in the same path if the IBM Data Server Driver for ODBC and CLI is already installed.
  • On Windows operating systems, you can install a maximum of 16 copies of the IBM Data Server Driver for ODBC and CLI.
  • To connect to a z/OS® server or a System i® server, you must register a Db2 Connect license key. (Retrieve the license file from your Passport Advantage® distribution, for example db2conpe.lic, then copy the license file to the license directory under the directory where the driver was installed.)
  • XA connections against a z/OS server are supported. However, XA connections against a System i server are not supported.
  • If you use the configuration file db2dsdriver.cfg to specify aliases, the following entries must contain a value:
    • <dsncollection> entries (alias, name, host, and port)
    • <database> entries (name, host, port).
    These entries must be specified and cannot be empty.
  • The CLI/ODBC configuration keyword DBNAME is not supported.
  • The CLI LOAD utility statement attribute, sql_attr_use_load_api, is not supported.

Functionality not supported by the IBM Data Server Driver for ODBC and CLI

Functionality supported with restrictions by the IBM Data Server Driver for ODBC and CLI