DB2 10.5 for Linux, UNIX, and Windows

Installing the IBM Data Server Driver for ODBC and CLI software on Linux and UNIX 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 db2_cli_odbc_driver subdirectory under the $HOME/db2user directory:
    mkdir $HOME/db2user/db2_cli_odbc_driver
    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:
    cp vxxxfpx_xxxxx_odbc_cli.tar.gz $HOME/db2user/db2_cli_odbc_driver 
  3. Extract and unarchive the IBM Data Server Driver for ODBC and CLI software file. Issue the gunzip command and the tar xvf command to extract and unarchive the IBM Data Server Driver for ODBC and CLI software file. Following command examples uncompress and unarchive the IBM Data Server Driver for ODBC and CLI software file:
    gunzip vxxxfpx_xxxxx_odbc_cli.tar.gz 
    tar -xvf vxxxfpx_xxxxx_odbc_cli.tar
    If you installed multiple copies of the IBM data server client products on a same system, ensure that your application references the correct IBM data server client installation. The use of the LD_LIBRARY_PATH environment variable (or LIBPATH in AIX® operating systems) can lead to inadvertent loading of the incorrect library files. To avoid loading an incorrect driver library, dynamically load the driver library from 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 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.
    rm vxxxfpx_xxxxx_odbc_cli.tar