Strange Error Messages

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
kris_r
Participant
Posts: 32
Joined: Mon Jun 26, 2006 3:09 am
Location: bangalore

Strange Error Messages

Post by kris_r »

Hi,
I am getting 2 different error messages in my datastage job.
My target database is DB2.


First Error Message
================
Job Name..DB2_UDB_API_0: [IBM][CLI Driver][DB2] SQL0443N Routine "SQLTABLES" (specific name "SQLTABLES") has returned an error SQLSTATE with diagnostic text "SQLCODE=-913 00C9008E". SQLSTATE=38113

SQLTables: Error retrieving system catalog information for requested tables(s).

Second Error Message
===============
Job Name..: [IBM][CLI Driver][DB2] SQL0902C A system error (reason code = "13") occurred. Subsequent SQL statements cannot be processed. SQLSTATE=58005

Just want to know why do we get these error messages and the way of resolving this.
Krazykoolrohit
Charter Member
Charter Member
Posts: 560
Joined: Wed Jul 13, 2005 5:36 am
Location: Ohio

Post by Krazykoolrohit »

contact your DBA and send these error messages to him.

I dont think its anything to do with your datastage jobs.
kris_r
Participant
Posts: 32
Joined: Mon Jun 26, 2006 3:09 am
Location: bangalore

Post by kris_r »

Any Idea why these error messages are coming..
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Let us know what your DBA says.
-craig

"You can never have too many knives" -- Logan Nine Fingers
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

We dont, but googledoes :P
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
kris_r
Participant
Posts: 32
Joined: Mon Jun 26, 2006 3:09 am
Location: bangalore

Post by kris_r »

Thanks DSguru, I will contact my DBA regarding this..
thanks a lot for the information...
Post Reply