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
what are bind concepts in db2 cobol?
What is the role of data manager in the db2 database?
What is load replace in db2?
What are the uses of db2 optimizer?
How do I import data from excel to db2?
How to view db2 table structure?
What is a system catalog table in db2?
How do you stop a db2 database in linux?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How do I start db2 in windows?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Differentiate between cs and rr isolation levels? Where do you specify them?
Define predicate?
What is a storage group (stogroup)?
What is ibm db2 used for?