Wednesday, 19 November 2008

DB2 ODBC

1. Get IBM Data Server Client from here http://www-01.ibm.com/software/data/db2/express/additional-downloads.html

2. It should be named like
v9.5_linuxia32_rtcl.tar.gz

3. Install it using XWindows GUI installation: rtcl/db2setup

4. During the installation process create a user named db2inst1

5. In a case of the successful installation perform the following steps:

5.1 [...~]$ su -
db2inst1
5.2
[...~]$ db2
5.3 => CATALOG TCPIP NODE MY_NODE REMOTE remote_host SERVER 50000
5.4 => CATALOG DB MY_DB AT NODE MY_NODE
5.5 => terminate
5.6
[...~]$ isql -v MY_DB
5.7 SQL> SELECT * FROM MY_TABLE


Interested in PostgreSQL? See the following blog: PostgreSQL