job crash handling

paddu · Post by **paddu** » Fri Mar 11, 2005 1:51 pm

hello

if my job crashes while running , how do i perform rollback in datastage.

kcbland · Post by **kcbland** » Fri Mar 11, 2005 2:21 pm

The transactions will rollback to the last commit. There's nothing you have to do. Now of course, if you're committing every 10K rows and your job crashes at 50K rows, you'll still have 40K rows inserted/updated. If you set to 0 the transaction count, you have one commit at the end so that a rollback is complete.

paddu · Post by **paddu** » Fri Mar 11, 2005 2:42 pm

thanks kenneth

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Sat Mar 12, 2005 3:34 am

Also use 'Reset and Run' in order to release / identify extra information on next run.