Disadvantage of delaying commits
Posted: Sun Sep 23, 2012 11:05 pm
Hi,
We are loading about 40 million records into a DB2 table using DataStage. If the load fails midway, we would like to rollback whatever changes were loaded in that session.
The load is incremental in nature. The only way I can think of is to set the transaction size to 0. But I'm not sure if this is going to come at a performance expense.
If delaying the commit till the end is going to cause accumulation of logs/rollback information, is there any other way to fulfill our requirement?
Thank You
We are loading about 40 million records into a DB2 table using DataStage. If the load fails midway, we would like to rollback whatever changes were loaded in that session.
The load is incremental in nature. The only way I can think of is to set the transaction size to 0. But I'm not sure if this is going to come at a performance expense.
If delaying the commit till the end is going to cause accumulation of logs/rollback information, is there any other way to fulfill our requirement?
Thank You