Configure UnixODBC to a DB2 V9.7 on a Linux
1. configure db2cli.ini
$ update /opt/ibm/db2/V9.7/cfg/db2cli.ini
[ODBCDB2]
Protocol=TCPIP4
Port=50000
Database=art
Hostname=192.168.1.189
UID=db2inst1
PWD=db2inst1
autocommit=0
$ export DB2CLIINIPATH=/opt/ibm/db2/V9.7/cfg
2. /etc/odbcinst.ini
[DB2V97]
Description = db2 odbc
Driver = /opt/ibm/db2/V9.7/lib64/libdb2.so
FileUsage = 1
DontDLClose = 1
3. ~/.odbc.ini
[ODBCDB2]
Driver = DB2V97
Description = db2 odbc
4. connect use isql
$ isql -v ODBCDB2
Please notice:
The ODBCDB2 must be same on all command line, ~/.odbc.ini, and /opt/ibm/db2/V9.7/cfg/db2cli.ini