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
- 6776 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 difference between plan and package in db2?
What is the maximum size of a char data type in db2?
How to restart a DB2 program?
What is netezza database?
Explain the function of data manager.
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is the physical storage length of timestamp data type?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Where do you specify them?
What are db2 objects?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is dbrm library?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Define check constraint.
What db2 400?
