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
 

 

DB2 Commit in CICS DB2 multi level program.....

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

New User


Joined: 12 Mar 2008
Posts: 7
Location: India

PostPosted: Fri Apr 01, 2011 8:53 am    Post subject: DB2 Commit in CICS DB2 multi level program.....
Reply with quote

CICS / DB2 PGM A links to CICS / DB2 PGM B... table1 is updated successfully in PGM B and table 2 update fails in WHEN OTHER condition in PGM B. Here we load err msg in commarea and execute CICS RETURN to go to PGM A. In this situation whether table1 update will be commited or not?

Assumption: both the program plan are not common. They have separate plans.


Please provide me an answer on whether the COMMIT will happen for table 1 update.
Back to top
View user's profile Send private message

Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1756
Location: UK

PostPosted: Fri Apr 01, 2011 9:45 am    Post subject:
Reply with quote

OK, what bit of the manual did you NOT understand with regards to COMMIT?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Apr 01, 2011 12:21 pm    Post subject:
Reply with quote

Boopathy,

since it is cics,
you need to understand syncpoint.

you should read about CICS Transaction Server for z/OS V3R1 CICS DB2 Guide
Back to top
View user's profile Send private message
rbrkumaran1

New User


Joined: 12 Mar 2008
Posts: 7
Location: India

PostPosted: Fri Apr 01, 2011 2:23 pm    Post subject:
Reply with quote

Nic Clouston wrote:
OK, what bit of the manual did you NOT understand with regards to COMMIT?


I do understand the concept of COMMIT and Syncpoint. The case I was explaining doesnt have them. I wanted to know how this kind of situation is handled, as my porject program has this kind of coding.

I got to know that the task number is assigned by CICS for the main program and till that task is completed, the commit will NOT be peformed though there were intermediate CICS RETURN stmts. CICS RETURN stmt should return the control to CICS to get the changes COMMITted. If the control is transferred to calling pgm, the COMMIT WILL NOT OCCUR.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1756
Location: UK

PostPosted: Fri Apr 01, 2011 3:03 pm    Post subject:
Reply with quote

Commits are always there - even if only by default.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Apr 01, 2011 4:04 pm    Post subject:
Reply with quote

the implicit commit performed by cics will not occur until the task has sucessfully completed - has nothing to do with xctls and xlinks.

if the tasks abends then cics will perform a rollback.

if your tasks end normally, then cics will perform a commit.

your situation sounds like you need to do an explict rollback when your second update fails, in order to back out the first updates - if you want to backout the first updates.


you talk about plans and prm xlinks/xctl was useless,
though it did let us know your skill level.
in cics (as in batch) everything is run under a package which includes the different plans.
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 SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm


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