| View previous topic :: View next topic |
| Author |
Message |
ignich7
Beginner
Joined: 29 Nov 2005
Posts: 14
Topics: 10
|
 Posted: Tue Dec 11, 2007 3:33 am Post subject: CICS syncpoint and DB2 commit |
 |
|
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?
Thanks in advance.
Gnana Nicholas I
_________________
GNANA NICHOLAS.I |
|
| Back to top |
|
 |
vkphani
Intermediate
Joined: 05 Sep 2003
Posts: 483
Topics: 48
|
| Posted: Tue Dec 11, 2007 3:58 am Post subject: |
|
|
GNANA NICHOLAS.I,
In that case, CICS will not rollback the changes made to DB2 tables. DB2 changes are made permanent if you issue a DB2 Commit. |
|
| Back to top |
|
|
dbzTHEdinosauer
Supermod
Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany
|
| Posted: Tue Dec 11, 2007 7:07 am Post subject: |
|
|
| Quote: |
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?
|
| Quote: |
If I issue DB2 commit within the LUW,
|
the commit defines the LUW.
| Quote: |
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?
|
all work done between a COMMIT and an ABEND (which will invoke a ROLLBACK) will be backed out from your db2 tables.
_________________
Dick Brenholtz
American living in Varel, Germany |
|
| Back to top |
|
|
CICS Guy
Intermediate
Joined: 30 Apr 2007
Posts: 292
Topics: 3
|
| Posted: Tue Dec 11, 2007 8:35 am Post subject: |
|
|
| Are DB2 COMMITs now allowed in a CICS environment? |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
