Issue with Transaction Commit
Posted: Thu May 17, 2012 12:06 am
Hi,
I have a server job which fetches data from a DB2 table based on the Flag value & inserts into another DB2 table. Also, one field (flag) in the source table is updated as and when data is loaded to the target DB2 table.
Db2 table (X) ---> Transformer -----> Db2 table (Y) & Db2 table update (X)
The issue is, if the jobs completes successfully, then the flag logic works fine. But if the job aborts in between, then the flag update done during the run is not reflected in the table X. And once we restart the job, the job starts from the beginning processing all the 'n' records. The implementation of the Flag logic is not working in this scenario.
I tried different settings of transaction Isolation & transaction size, but it didn't help.
Please help me with the exact settings that needs to be done.
Thanks,
dxk9
I have a server job which fetches data from a DB2 table based on the Flag value & inserts into another DB2 table. Also, one field (flag) in the source table is updated as and when data is loaded to the target DB2 table.
Db2 table (X) ---> Transformer -----> Db2 table (Y) & Db2 table update (X)
The issue is, if the jobs completes successfully, then the flag logic works fine. But if the job aborts in between, then the flag update done during the run is not reflected in the table X. And once we restart the job, the job starts from the beginning processing all the 'n' records. The implementation of the Flag logic is not working in this scenario.
I tried different settings of transaction Isolation & transaction size, but it didn't help.
Please help me with the exact settings that needs to be done.
Thanks,
dxk9