DSXchange

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.

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.

Question answered

Thanks chulett