Installing the unixODBC driver manager

The unixODBC driver manager is an open source ODBC driver manager that can be used with the Db2® ODBC driver on all supported Linux® and UNIX operating systems.

Procedure

To install the unixODBC driver manager:

  1. Obtain the unixODBC driver manager.
  2. Install the unixODBC driver manager.
    You can issue the apt-get install command to install the unixODBC driver manager:
    apt-get install unixodbc unixodbc-dev
    Tip: You can also use different package manager command that is based on your operating system architecture and distribution to install a compiled version of the unixODBC driver manager. For example, on Red-Hat Linux operating system, you can use the yum command:
    yum install unixODBC unixODBC-devel
  3. Configure the unixODBC driver manager by adding the following lines in the odbcinst.ini configuration file:
    [Db2]
    Description = Db2 Driver
    Driver = <instance_path>/lib/libdb2o.so
    fileusage=1
    dontdlclose=1
    if you installed the full IBM®, the <instance_path> is your Db2 instance path, such as IBM Data Server Client, IBM Data Server Runtime Client, or Db2 database server product. If you installed the IBM Data Server Driver for ODBC and CLI, the <instance_path> is your installation path. You can determine the location of the odbcinst.ini configuration file by issuing the following command:
    odbcinst –j
    For more information about configuring the unixODBC driver manager, see links in the related reference topics.