Restartable Sequence with Exception handler

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
harryhome
Participant
Posts: 112
Joined: Wed Oct 18, 2006 7:10 am

Restartable Sequence with Exception handler

Post by harryhome »

Here is the scenario,

In a restartable sequence which will on failure sets a checkpoint and in subsequent run starts from that checkpoint.
If we plug a exception handler, then the checkpoint is not saved on failure and in subsequent run the sequence will start from scrach.

I have few jobs which need to be ran on failure of sequence using Exception handler activity and at the same time I need the Sequence to be restartable, any views?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You are seeking to have your cake and eat it too. You can have one or the other, but not both. Invoking the Exception Handler causes the sequence to finish successfully, which clears all checkpoints. Use explicit failure triggers instead.
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