Error in DB2 stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kalpanam
Participant
Posts: 39
Joined: Sat Apr 19, 2008 6:14 am

Error in DB2 stage

Post by kalpanam »

Hi All,

I have job design as:

Dataset---->modify------>DB2 table where i have used update statment.

When i run the job individually means,it is completing successfully but when i run the job in sequence means it is aborting giving the error:db2CS_ORDER_FACT: ERROR during execution of DB2-CLI requests: SQL_ERROR; SQLSTATE = 42S02; NativeErrorCode = -204; Message = [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N "CDW_STG.CS_ORDER_FACT" is an undefined name. SQLSTATE=42704

Could anyone please tell me why this job is failyng ?

Thanks & Regards,
Kalpana.
Kalpana Marupudi
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Your DB2 DBA would probably be able to help. As noted in your other post, the error is coming from DB2.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Althaf6553
Participant
Posts: 64
Joined: Wed Sep 26, 2007 6:52 am
Location: Syracuse ,NY

Post by Althaf6553 »

The database credentials that you are passing in the sequence would be wrong .Please check them.Looks like its the schema name which is wrong
Althaf
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”