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.

To install the unixODBC driver manager:

1. Obtain the unixODBC driver manager.
   • You can download and compile the unixODBC driver manager source code. For information about compiling the source code, see Compiling the unixODBC driver manager.
   • You can download the compiled version of the unixODBC driver manager from the following URLs:
     1. For an AIX® RPM file, see http://www.perzl.org/aix/index.php?n=Main.UnixODBC
     2. For a Linux RPM file, see http://rpmfind.net/linux/rpm2html/search.php?query=unixODBC
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

   The <instance_path> is your DB2 instance path if you installed the full IBM®, 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.