When DS job aborts, rows are still insterted into target DB

Marley777 · Post by **Marley777** » Thu Jun 16, 2011 2:08 pm

Hi, thanks for reading. Running a parallel job and noticed when it aborts it still inserts rows into the target table. Does DataStage not have roll back capability?

Job design

Dataset -> lookup -> transformer -> DB2 Connector

ray.wurlod · Post by **ray.wurlod** » Thu Jun 16, 2011 2:37 pm

Depends on your Array Size and Transaction Size settings. All of the rows in a committed array will get into the database even if the job aborts (because the COMMIT is sent before the job aborts). Once a COMMIT has been sent, rollback is not available - standard database practice.