Job crashes in middle how to perform roll back

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
kiran_418
Participant
Posts: 40
Joined: Tue Feb 22, 2005 11:12 am

Job crashes in middle how to perform roll back

Post by kiran_418 »

HI
How to handle rollback in datastage when a job crashes in middle of run. I have a job that inserts 3 million records into oracle database. But after some time jobs craches due to some reasons. In that scenario how will datastage handle that scenario.
Thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It will do whatever you design it to do.

Enrol in the "best practices" class, which shows techniques for staging data and recording process metadata so that you can figure out what was loaded and what wasn't.

And please post on the correct forum (server job forum?).
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