DB2 Roll Back

Marley777 · Post by **Marley777** » Wed Aug 14, 2013 11:59 am

Hi, thanks for reading.

I have a DS PX job that is designed to delete data based on keys I provide. The table is a db2 table. My commit count is set to 25000. If my job aborts and I have processed 30000 rows...will all 30000 rows get rolled back or just the 10000 that wasn't commited yet? Trying to figure out how the db2 roll back works when a datastage job aborts?

Thanks for any help.

chulett · Post by **chulett** » Wed Aug 14, 2013 1:08 pm

When a job aborts, any uncommitted records are rolled back. This isn't a DataStage thing but rather a database thing, one can only roll back uncommitted transactions.

Marley777 · Post by **Marley777** » Wed Aug 14, 2013 1:14 pm

Question answered

Thanks chulett