DB2 error when I run the job

suresh.narasimha · Post by **suresh.narasimha** » Tue Jul 26, 2011 2:02 am

Hello

My job aborted with a DB2 message " [IBM][CLI Driver][DB2] SQL0471N Invocation of routine "SYSIBM.SQLTABLES" failed due to reason "00E7900C". SQLSTATE=55023 "

I have searched forum, but could not find appropriate post.

Regarding my job, I'm using a db2 stage and writing into a file, I was able to view data through DataStage data browser. The query is a straight select statement.

And when I ran the job it aborted with the message above. To troubleshoot, I logged into DB2 database and the user has execute privilege to SYSIBM.SQLTABLES (execute privilege has been given to PUBLIC)

I'm not sure where exactly it is going wrong.

Could you please advise me on this ?

Thanks
Suresh

ray.wurlod · Post by **ray.wurlod** » Tue Jul 26, 2011 2:54 am

Search a DB2 forum or Google. What do these particular DB2 error codes mean?

chulett · Post by **chulett** » Tue Jul 26, 2011 8:03 am

Yup, Google brings what seems to be the error and solution right up if you are feeling lucky.

suresh.narasimha · Post by **suresh.narasimha** » Tue Aug 02, 2011 12:13 am

Hi,

I have searched google and found the link that you have posted, but I wanted to make sure before I go to the DBA and ask him to enable the stored proc.

the issue has been resolved, stored procedure was not enabled due to some upgrade in db2 database.

Thanks for yor help.