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

Explain transactions, commits and rollbacks in DB2.

Answer Posted / s

Transactions are programs that run under the transaction
managers like CICS, IMS/TM. Transactions require excellent
response times.

Commit makes the database changes permanent that was made
during a unit of recovery ie. from one consistency point to
another.

Rollbacks reverses the changes made to the database during
a unit of recovery.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What parameters are used to control the free space in DB2?

1057


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1046


What is null indicator in db2?

1114


How can you quickly find out the # of rows updated after an update statement?

1049


What is alias in db2?

1063


What is the function of logging in the db2 database?

1123


How to find schema of a table in db2?

1017


What is cascading rollback?

1215


What is dbrm?

1106


What are the bind parameters ibm db2?

1053


What is a system catalog table in db2?

1187


My sql statement select avg(salary) from emp yields inaccurate results. Why?

1095


What do you mean by storage group (stogroup)?

1041


What is the role of schema in the db2 database?

1276


Give a brief description of db2 isolation levels?

1074