Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Identifying Interfaces in CICS/mainframe Ashishpanpaliya CICS 5 Fri Oct 13, 2017 3:21 pm
No new posts Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm
No new posts Partial color change of a field in CI... waseem0424 CICS 5 Fri Sep 29, 2017 7:56 pm
No new posts FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 1 Mon Sep 18, 2017 4:31 pm
No new posts Julian Date to CICS ABSTTIME blayek CICS 3 Wed Aug 30, 2017 11:15 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us