hello
if my job crashes while running , how do i perform rollback in datastage.
job crash handling
Moderators: chulett, rschirm, roy
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom