DB2 stage giving problems....

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
narasimhareddy
Participant
Posts: 10
Joined: Wed Nov 30, 2005 8:12 am

DB2 stage giving problems....

Post by narasimhareddy »

My target is DB2. i am using DB2 enterprise stage.
following fata errors r giving...
can any one suggest me...
DB2_UDB_Enterprise_57,0: DB2 Load Binary Error.
DB2_UDB_Enterprise_57,0: SQLCODE = -3508; SQLSTATE= ?????/tmp/APT_DB2_LOADMSG_db2inst10_REMOTE
DB2_UDB_Enterprise_57,0: SQL3508N Error in accessing a file or path of type "MSGFILE" during load or load query. Reason code: "1". Path: "/tmp/APT_DB2_LOADMSG_db2inst10".
DB2_UDB_Enterprise_57,0: Failed opening fifo /tmp/ordb226440173c687b_.000 after 90 seconds: No such device or address.
DB2_UDB_Enterprise_57,0: The runLocally() of the operator failed.
DB2_UDB_Enterprise_57,0: Input 0 consumed 0 records.

Regards,
Reddy.
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Here, take a look at this page on why that error occured and what to do to fix it.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
narasimhareddy
Participant
Posts: 10
Joined: Wed Nov 30, 2005 8:12 am

getting differenet Fatal errror for each time..... f

Post by narasimhareddy »

DSguru2B wrote:Here, take a look at this page on why that error occured and what to do to fix it.
Thanks for valuable suggestion... but...

Today i am getting different Fatal error... as follows...

DB2_UDB_Enterprise_57: The db2 node `uhqt3cdb01.rei.com' does not exist in the apt configuration file.
main_program: Could not check all operators because of previous error(s)
main_program: Creation of a step finished with status = FAILED.


Can any one suggest me...

Regards,
N Reddy.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The db2 node 'uhqt3cdb01.rei.com' does not exist in the apt configuration file.
Put it in the configuration file!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply