IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Understanding Syncpoint :


IBM Mainframe Forums -> CICS
Post new topic   Reply to topic
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
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

Moderator Emeritus


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

PostPosted: Sat Jul 13, 2013 10:50 pm
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

Global Moderator


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

PostPosted: Sun Jul 14, 2013 12:08 pm
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: 204
Location: Globe, India

PostPosted: Thu Aug 08, 2013 11:29 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CICS

 


Similar Topics
Topic Forum Replies
No new posts MQPMO-NO-SYNCPOINT Java & MQSeries 19
No new posts Need Help in understanding what is th... PL/I & Assembler 9
No new posts Understanding Program Objects All Other Mainframe Topics 5
No new posts How to place SYNCPOINT in VSAM . CICS 2
No new posts TWA variable having junk value after ... CICS 1
Search our Forums:

Back to Top