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
- 6775 Views
- I also Faced
- E-Mail Answers
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 dbrm? What it contains? When it will be created?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is the syntax for seeing the columns and data types of a table in the db2 database?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
What is DB2 (IBM Database 2)?
When do you specify the isolation level? How?
How does the processing of a correlated subquery differ from a non correlated subquery?
Define check constraint.
What os does db2 run on?
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
What is the meaning concurrency in the db2 database?
COBOL 
