Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

CICS syncpoint and DB2 commit

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
ignich7

New User


Joined: 02 Nov 2005
Posts: 65

PostPosted: Tue Dec 11, 2007 1:38 pm    Post subject: CICS syncpoint and DB2 commit
Reply with 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?

Gnana Nicholas I
Back to top
View user's profile Send private message

TG Murphy

Active User


Joined: 23 Mar 2007
Posts: 149
Location: Ottawa Canada

PostPosted: Fri Dec 14, 2007 1:32 am    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Dec 14, 2007 2:52 am    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm
No new posts Asynchronous CICS Processing Question moezbud CICS 0 Mon Mar 06, 2017 6:13 pm
No new posts CICS Question RE: Browse, Readnext an... moezbud CICS 7 Sun Mar 05, 2017 5:45 am
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Mainframe Interview Questions CICS,CO... akshathan Mainframe Interview Questions 6 Thu Feb 09, 2017 6:38 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us