Roll back is not working
Posted: Mon May 16, 2011 5:02 am
Hi All,
We have following job design in server.
Some Processing ----> Transformer. Two out put links from transformer
1) Db2 Stage (writes into DB2 database)
2) Aggregator - It has one out put link to 2nd Db2 Stage (Writes into Iseries file)
Transaction size in both the DB2 stage is set to zero. Our job gets aborted due to access issue in Iseries file (2nd Db2 Stage). But even that Job committed the Data in Db2 database (1st Db2 stage). It didn't rollback the Data. Please explain why it is happening.
Is there any way to set the commit after the job successful completion other wise rollback?
We have following job design in server.
Some Processing ----> Transformer. Two out put links from transformer
1) Db2 Stage (writes into DB2 database)
2) Aggregator - It has one out put link to 2nd Db2 Stage (Writes into Iseries file)
Transaction size in both the DB2 stage is set to zero. Our job gets aborted due to access issue in Iseries file (2nd Db2 Stage). But even that Job committed the Data in Db2 database (1st Db2 stage). It didn't rollback the Data. Please explain why it is happening.
Is there any way to set the commit after the job successful completion other wise rollback?