A Client for IBM DB2 7.2 AIX

问题:

• I have an old AIX box running IBM DB2 7.2.

• I need to get some data from some of the instances of some of the databases

  • I tried Quest TOAD for Data Analysts which gives me the driver is not compatible
  • I tried IBM Data Studio 4.1.2 : can connect but "invalid operation " and then shows nothing
  • I tried SQL Workbench/J 122: idem

So I wonder what client/tool I can use to browse the Db2 instance-databases from a Windows 7 laptop (there is no 7.2 mentioned on this overview: http://www-01.ibm.com/support/docview.wss?uid=swg21363866)

UPDATE Installing the version 9.1 client still gives me "SQL5048N The release level of the database client is not supported by the release level of the database server"

回答1:

Modern DB2 JDBC drivers (JCC, also called type 4) are not compatible with DB2 7.2 -- you will need either type 1 ("net") or type 2 ("app") JDBC driver, both rely on native DB2 CLI libraries installed.

Typically DB2 clients are backwards-compatible up to 2 versions down, so version 9.5 and 9.1 drivers should work, at least partially (with the exception of features unsupported by the version 7.2 server).

Download and install the full Data Server Client then you can refer to this question for how to configure client connectivity.