View previous topic :: View next topic
|
Author |
Message |
sreelu.s
New User
Joined: 23 Jul 2010 Posts: 10 Location: hyderabad
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
Also upto you to decide on the unit of work |
|
Back to top |
|
|
rohanthengal
Active User
Joined: 19 Mar 2009 Posts: 206 Location: Globe, India
|
|
|
|
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 |
|
|
|