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
- 6768 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
What is the syntax for creating a table in the db2 database?
What is universal database?
How can you classify the locks in db2?
What are the prerogatives?
What is a dbrm in db2?
How do I change the column size in db2?
What is dpf in db2?
What is cursor with hold option in db2?
What is database alias db2?
What is the difference between cursor stability and repeatable read isolation levels?
can all users have the privilage to use the sql statement select * (dml)?
Which component is responsible for db2 startup and shutdown?
How do you concatenate the firstname and lastname from emp table to give a complete name?
How can you do the explain of a dynamic sql statement?
What is the information associated with sysibm.syslinks table?
