What syncpoint command does in the pgm

sierra_angel · New User Joined: 06 Sep 2006 Posts: 1 Location: Malaysia

Hello there!

I would like to ask what syncpoint command does in the pgm?. Is this really help to release the resources?
E.g. System 1(Screen1) do a tranx, then System 2 (screen2) is also doing a tranx, then screen 2 abended with error SQL 911 (contention with Screen1).
Screen1 calls a program that updates the file (FILE1) w/c Screen2 also using.
With this, they told me to use the SYNPOINT command in screen 1 as per their explanation this is not to hold FILE1 too long (to release FILE1) so that other screens can access the FILE1.
Thanks!

raghunathns · Posted: Thu Sep 07, 2006 2:46 am

syncpoint is similar to commit.

if you update a record then it will held until you issue syncpoint or end of transaction.

if you issue syncpoint rollback. your updates will be cancelled.