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:
- 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:
- For an AIX® RPM file, see http://www.perzl.org/aix/index.php?n=Main.UnixODBC
- For a Linux RPM file, see http://rpmfind.net/linux/rpm2html/search.php?query=unixODBC
- 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
- Configure the unixODBC driver manager by adding the following
lines in the odbcinst.ini configuration file:
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:[Db2] Description = Db2 Driver Driver = <instance_path>/lib/libdb2o.so fileusage=1 dontdlclose=1
For more information about configuring the unixODBC driver manager, see links in the related reference topics.odbcinst –j