DSXchange

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.

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