DB2 error when I run the job
Posted: 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
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