If I issue DB2 commit within the LUW, after some time the transaction got ABEND before the completion of LUW. In this case, will CICS rollback the changes made to DB2 tables or it will only recover the CICS-recoverable resources?
Joined: 23 Mar 2007 Posts: 149 Location: Ottawa Canada
You say that you issued the DB2 commit. Question: Did this commit finish successfully? Or did the commit itself fail?
In any case, any data that is committed is .... well .... committed. It will not be rolled back. Rollback only rolls back data that is uncommitted.
By the way, we are talking about a CICS transaction here, right? So don't be using the DB2 commit command. Instead you need to use the CICS SYNCPOINT command. SYNCPOINT itself will talk to DB2 to ensure the DB2 commit happens but you need to leave that business to SYNCPOINT.