Configuring the DB2 native ODBC driver on AIX

To configure and use the DB2 ODBC driver on AIX operating systems, you must modify the DB2 environment variables and the ODBCINI environment variable.

Before you begin

  • Confirm that your system meets the system requirements and that you are using a supported version of IBM® DB2® database systems. For more information, see System Requirements.

Procedure

  1. Update the 64-bit ODBC driver for DB2 on AIX operating systems so that the DataDirect driver manager can load the ODBC driver:
    1. Open the db2o.o driver file, which is in the $DB2_HOME/sqllib/lib64 directory.
    2. In the db2o.o driver file, add a link to the db2o.o.so file. For example, you can add the following link: ln -s db2o.o db2o.o.so
  2. Add the following entry to the $ODBCINI file. The DataDirect driver manager uses the DriverUnicodeType=1 entry to work with the ODBC driver for DB2. 
    ****************************************************
****************************************************
Driver=/home/db2inst1/sqllib/lib64/db2o.o.so
DriverUnicodeType=1
  3. Set the DB2INSTANCE environment variable to the instance in the DB2 client in which you cataloged the target database.
  4. Add the path to the directory that contains the client libraries to the library path environment variable.