DB2 configure unixODBC

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