Sequencer restart/resume job: Handle uncommited records

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
AKUMAR21
Participant
Posts: 30
Joined: Fri Jul 20, 2007 12:44 am
Location: Chennai

Sequencer restart/resume job: Handle uncommited records

Post by AKUMAR21 »

I have a sequence job that runs 25 jobs in parallel. Each of the 25 jobs uses separate MQ stage that destructivley reads records from separate MQ and loads into Teradata through TPUMP stage. In case a job aborts, how to handle those records that were destructively read from MQ and that failed to commit to Teadata? Can we restart/resume the job from sequencer without losing any data?
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

I would add writing the MQ-Series record to a sequential file so that it isn't lost should the job abort. You cannot restart the sequence without losing data unless you explicitly program storing the interim data.
Post Reply