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).
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 |
What is node in db2?
What is the error code -803 ?
What is reorg in database?
What are the contents of dclgen?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
What does the REORG Utility do?
What r the comman abends in db2, jcl and cobol???????
Where can you declare a cursor in a cobol-db2 program?
Describe major components of db2?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
What is the default page size of buffer pools?