Tolik Gusin wrote:
Hello All,
Whether supports DB2 UDB 8.2 FP7 for Linux the ODBC-driver ?
If yes, whether that enters this driver into delivery DB2 UDB 8.2 FP7
for Linux ?
If it is possible, bring please an example of customization of the
ODBC-driver for DB2 under Linux.
Hello Tolik.
I realise you aren't a native English speaker (Ukraine ?) so hopefully you
can understand the following -
The ODBC driver for DB2 on Linux is all within the db2cli (CLI is bigger
than ODBC, but ODBC is a subset of it).
You will need to install the unixODBC package. You don't say which Linux
distro you are running, so positions of files etc may vary. I'm using SuSE
Pro 9.3 and my config files are under /etc/unixODBC. The files are -
odbcinst.ini (this defines the driver details)
============
[DB2]
Description = DB2 Driver
Driver = /opt/IBM/db2/V8.1/lib/libdb2.so
Driver64 =
Setup =
Setup64 =
UsageCount =
CPTimeout =
CPReuse =
FileUsage = 1
DontDLClose = 1
odbc.ini (data sources : individual databases)
========
[DBAIR001]
Description = Aircraft Database
Driver = DB2
[FSITEST]
Description = FSI Test
Driver = DB2
The data source name (in square brackets) relates to the cataloged database
alias name. The "Driver = DB2" points back to the [DB2] definition on
odbcinst.ini.
The graphical ODBC admin tools on SuSE 9.3 didn't seem to work for me, so I
had to configure this manually, using some docs at
http://www.unixodbc.org
(which I found by searching on Google for "ODBC DB2"
HTH
Phil