DataStage 7.5.3 with DB2

sarat.srinivas@tcs.com · Wed Feb 03, 2010 3:46 am

Hi,

We have created a DSN for accessing the DB2 DB using IBM DB2 ODBC Driver & when we executed the DataStage Server job for either extract ( or ) load, we were getting the execution error that "IBM][CLI Driver][DB2] SQL0471N Invocation of routine "SYSIBM.SQLTABLES" failed due to reason "00E7900C". SQLSTATE=55023". So, recreated the DSN using IBM (Data Direct) DB2 Wire Protocol driver, but the same error existed.

Please advice the resolution.

Thanks,
Sarat.

ArndW · Post by **ArndW** » Wed Feb 03, 2010 5:25 am

Can you do a DB2 CONNECT to the same DB2 instance from the command line? The error indicates that the environment cannot be reached.