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
 
Understanding Syncpoint :

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

New User


Joined: 23 Jul 2010
Posts: 10
Location: hyderabad

PostPosted: Sat Jul 13, 2013 1:57 am    Post subject: Understanding Syncpoint :
Reply with quote

Can someone help me in understanding this : Suppose I have a sequence of statements as below :

1. syncpoint
2. table1 update
3. link to pgmb ( i have a syncpoint in the starting of the program )
4. table 2 update ...

Suppose my table 2 update was not successful and hence in the abend-processing paragraph , have issued a Syncpoint Rollback .

Will it take the Latest syncpoint as the point 1 ( present in the main program ) or the syncpoint of the pgmb (linked program ) ?
I mean -- will the table 1 update is rollbacked ?

Please help me in understanding the case where in I have multiple syncpoints in a single program even. Thanks in Advance.
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: Sat Jul 13, 2013 10:50 pm    Post subject:
Reply with quote

Hello,

Any insert/delete/update issued after a syncpoint should be rolled back - automatically.

Even if you wanted to undo prior work the rollback is until the last syncpoint . . .
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1542
Location: Andromeda Galaxy

PostPosted: Sun Jul 14, 2013 12:08 pm    Post subject:
Reply with quote

Also upto you to decide on the unit of work
Back to top
View user's profile Send private message
rohanthengal

Active User


Joined: 19 Mar 2009
Posts: 181
Location: Globe, India

PostPosted: Thu Aug 08, 2013 11:29 am    Post subject:
Reply with quote

rollback will be done till last executed syncpoint/commit...
So, in your case rollback will happen for the queries which got executed after the SYNCPOINT given in --- PGMB and SYNCPOINT ROLLBACK.
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 Need Help in understanding what is th... mainakdalal PL/I & Assembler 9 Mon Oct 03, 2016 8:03 pm
No new posts Understanding Program Objects jerryte All Other Mainframe Topics 5 Tue Apr 14, 2015 12:53 am
No new posts How to place SYNCPOINT in VSAM . ShobhitVerma10april CICS 2 Thu Jul 03, 2014 11:14 am
No new posts TWA variable having junk value after ... Gopalakrishnan V CICS 1 Tue May 13, 2014 7:59 pm
No new posts Need Help on the understanding of the... ashim prodhan PL/I & Assembler 3 Mon Feb 17, 2014 7:55 pm

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