Search code examples
oracle-databasejdbcdb2ibm-midrange

jdbc driver to connect to db2 7.1 as400


I need to connect to db2 7.1 as400 system using sqldeveloper & oracle data integrator using jdbc driver.

I downloaded db2cc.jar, db2cc_license_cisuz.jar..jt400.jar, db2java.jar.

The connection shows success and it appears to be connected, but while running any query or browsing any table, every time I get below error:

SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSLH200;00;S0681e7r ,DRIVER=3.59.81

Solution

  • Ask your DB2 support person or DBA to ensure that db2clipkg.bnd is appropriately bound (or rebound) for your environment - using db2jdbcbind. More information at IBM-doclink