DSXchange

Posted: **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

Posted: **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.

DSXchange

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

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