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 parameters are used to control the free space in DB2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is null indicator in db2?
How can you quickly find out the # of rows updated after an update statement?
What is alias in db2?
What is the function of logging in the db2 database?
How to find schema of a table in db2?
What is cascading rollback?
What is dbrm?
What are the bind parameters ibm db2?
What is a system catalog table in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What do you mean by storage group (stogroup)?
What is the role of schema in the db2 database?
Give a brief description of db2 isolation levels?