Restart Datastage Job/Sequence

[balu536]

Hello Everyone,
I don't know whether this topic is already discussed, but i couldn't find it in the search list.

I have a datastage sequence which contains 10 jobs and say suppose in 3 rd(source having 10000 records) job after loading 9000 records to target, job got aborted.

Now when restarting the sequence, i want the sequence to be re-started from the 9001 record in 3rd sequence rather than restarting the 3rd sequence from first record.

Please help me on this.

[ray.wurlod]

It has been discussed a number of times in the past. Basically you have to design the 3rd job so that it can pick up where it left off - there is no automatic mechanism for achieving this. The design, clearly, involves some kind of persistent "remembering" which rows have been processed successfully.

[chulett]

And will also require a static source.

[ray.wurlod]

Part of the restartability design might well involve capturing a snapshot that you can use when restarting.

[kduke]

This is easily solved if insert and update is decided in the current job. Too many people decide this in a prior job and then write out a insert dataset and a update dataset. This will always cause problems if you ask me.