View previous topic :: View next topic
|
Author |
Message |
ignich7
New User
Joined: 02 Nov 2005 Posts: 66
|
|
|
|
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?
Gnana Nicholas I |
|
Back to top |
|
|
TG Murphy
Active User
Joined: 23 Mar 2007 Posts: 148 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. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
If I issue DB2 commit within the LUW, after some time the transaction got ABEND before the completion of LUW. |
FWIW, on all of the database engines i've supported, a commit ends a database LUW and another is started.
As was suggested, in your situation do not issue the database commit within the CICS transaction. |
|
Back to top |
|
|
|