Installing the IBM Data Server Driver for ODBC and CLI software on Windows operating systems

The IBM Data Server Driver for ODBC and CLI software is a small footprint IBM data server product that provides runtime support for the CLI application programming interface (API) and the ODBC API. The IBM Data Server Driver for ODBC and CLI software does not contain installation program and you must install it manually.

The IBM Data Server Driver for ODBC and CLI product is a lightweight deployment solution that is designed for independent software vendors (ISV) deployments.

Procedure

  1. Create a directory for installation of the IBM Data Server Driver for ODBC and CLI software.
    Following example creates C:\IBMDB2\CLIDRIVER\ directory when command issue from the C:\ directory:
    mkdir IBMDB2\CLIDRIVER\
    You can install multiple copies of the IBM Data Server Driver for ODBC and CLI software, each on a separate unique directory.
  2. Copy the IBM Data Server Driver for ODBC and CLI software that is distributed in compressed file format into the target directory.
    Following command example copies the IBM Data Server Driver for ODBC and CLI software file into a target installation directory:
    copy vxxxfpx_ntxxx_odbc_cli.zip C:\IBMDB2\CLIDRIVER\
  3. Extract the IBM Data Server Driver for ODBC and CLI software file.
    To extract the file, you can use third-party software or right click the IBM Data Server Driver for ODBC and CLI software file in Windows explorer. If you install multiple copies of the IBM data server client products on a same system, ensure that your application references the correct IBM data server client files. The use of the $PATH environment variable can lead to inadvertent loading of the incorrect library files. To avoid loading an incorrect driver library, dynamically load the driver library form the target installation directory within your application.
    Ensure that the following requirements are met if you installed the IBM Data Server Driver for ODBC and CLI software on a network file system (NFS):
    • The following directories must have global write permission
      • db2dump
      • db2
      • The path that is referenced in the diagpath parameter
    • If Db2® for z/OS® or Db2 for IBM i servers are being accessed directly, you must ensure that the license directory has both global read and write permissions.
  4. Optional: Remove the archived IBM Data Server Driver for ODBC and CLI software file.
    Following example removes the archived IBM Data Server Driver for ODBC and CLI software file.
    del vxxxfpx_ntxxx_odbc_cli.zip
  5. Register the CLI driver with Windows ODBC driver manager by issuing the db2cli install -setup command with administrator authority. The db2cli install -setup command also creates sample configuration files in the application data path.
    Following command registers the CLI driver with Windows ODBC driver manager:
    db2cli install -setup