Interested to Buy Any Domain ? << Click Here >> for more details...
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 Answers
- 6582 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Give a brief description of db2 isolation levels?
Mention the various locks that are available in db2.
What is precompiler in db2?
How to rename a table in DB2 ?
How and when does the db2 enforces the unique key?
What is db2 connect?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is dpf in db2?
How to access db2 tables in mainframe?
What is difference between rollback and commit?
What are concurrency issues?
How do I change the column size in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is a db2 table?
