Abnormal termination of stage

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
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Do a "reset" of the job, and post the log entry that starts with "from previous run..."
lindatgeorge
Participant
Posts: 34
Joined: Mon Jun 15, 2009 12:16 am
Location: Bangalore

Post by lindatgeorge »

Hi ArndW,

After resetting, I got the below message.

Resetting stage <transformer stagename>
Finished Resetting stage <transformer stagename>
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

As a server job, there will almost certainly be an entry in the log file after resetting which will show the termination cause and address. Are you certain that those are the only 2 log entries generated by the "reset", and did you reset from an aborted state?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What are the transaction and array sizes in the Oracle stage that writes data into the database? If these are too large they can cause this problem.
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