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

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).



1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts..

Answer / akbar.

SYNCPOINT ROLLBACK will rollback to the last COMMIT point
that has been made after any update in the same task.
Having said that, if PGMA and/or PGMC, in this case have
updated the database, has/have used COMMIT after their
respective updates, then ROLLBACK of PGMB after abend would
return to the very recent COMMIT made by either of the two
programs PGMA or PGMC.

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More DB2 Interview Questions

What is normalization and what are the five normal forms?

1 Answers  


what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?

3 Answers   Cap Gemini, Tech Mahindra,


What will happen, while trying to close the closed cursor.

1 Answers  


What is cursor with hold option in db2?

0 Answers  


what are extents?

5 Answers  






query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,


How many buffer pools are there in DB2?

2 Answers  


what is a trigger and types of triggers

3 Answers   HSBC,


What is a lock?

1 Answers  


what are the bind parameters?

5 Answers   IBM,


I use CS and update a page. Will the lock be released after I am done with that page?

2 Answers  


what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,


Categories