Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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).

Question Posted / ganeshcpande


1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts..

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

Post New Answer

More DB2 Interview Questions

What is a DB2 bind?

3 Answers  

What is the purpose of rollback and commit?

0 Answers  

How do you stop a db2 database in linux?

0 Answers  

wht displays the number of times a query modified ?

2 Answers   TCS,

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

0 Answers  

How do you eliminate duplicate values in db2?

0 Answers  

what is a trigger and types of triggers

3 Answers   HSBC,

Is db2 free?

0 Answers  

how to resolve -805. give clear explination for that

2 Answers   IBM,

How connect db2 database to datastage?

0 Answers  

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

What is the connection string to connect to the DB2 Database ?

0 Answers   MCN Solutions,

For more DB2 Interview Questions Click Here
Categories