CICS - DB2 - SYNCPOINT ROLLBACK

Hema_Manyam · New User Joined: 07 Dec 2005 Posts: 1

Hi , I have CICS - DB2 query.

1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms.

2) Say PGMC has done its work successfully and returned to PGMB

3) PGMB had an SQL error while doing some update

4) PGMA has already done some updates before calling PGMB

Note: There is no explicit syncpoint in these programs, all are running under the same CICS region.

What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).

Please clarify..

Thanks in Advance
Hema

srini_igsi · New User Joined: 09 Dec 2005 Posts: 34 Location: Pune

Hi
I dont think u r explicitly needed to issue ROLLBACK, as u r saying that there is no explicit COMMIT in any of the three pgms, so if any thing goes wrong the DB2 itself will ROLLBACK all changes that have been done so far.

correct me if am wrong.