JobSequence restartability after failure

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
satheesh_color
Participant
Posts: 182
Joined: Thu Jun 16, 2005 2:05 am

JobSequence restartability after failure

Post by satheesh_color »

Hi All,

I have a master sequence(Multiple instance job) and enable Add checkpoints and automatically handle activities that fail and the job contains exception_handler as well.

Yesterday one of the instance jobsequence got aboeted with aborted/restartable and the main job_control batch got aborted.we left the job as it is.When we ran the job today it throws the below error for the instance JobSeqLoadDMSalePsaCatWeekPrior.5870:

JobSeqLoadDMSalePsaCatWeekPrior.5870.JobControl (@Coordinator): Sequence job is being restarted after failure
Checkpoint record last modified at 2009-02-25 00:19:37

The current job run does not have the same parameters as its checkpoint record.The checkpointed parameter values were:

SourceDate=20090223 [current run=20090225]
FilePath=/dstage/appl/sat
StartDayId=5870
EndDayId=5876

and the sequence JobSeqLoadDMSalePsaCatWeekPrior.5870 completed with warnings and the batch_control job got aborted.

Please le me know how can we find the resolution of this problem.How do we ran the full re-run the job.

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

Post by ray.wurlod »

You run it with the same parameters. Or you re-run the entire sequence. These are your only options.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
satheesh_color
Participant
Posts: 182
Joined: Thu Jun 16, 2005 2:05 am

Post by satheesh_color »

Thanks Ray
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You certainly are allowed to restart a checkpointed job with different parameters, but it will log an extra message about the fact that they are different. Now, whether that will work properly or not based on your jobs is a whole 'nuther kettle of fish.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply