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
Which component is responsible for processing sql statements and selecting access paths?
How many types of page locks can be held in db2?
Explain what are the various isolation levels possible?
What types of tables are there in the db2 database?
What is meant by explain?
Which isolation level provides maximum concurrency?
How would you find out the total number of rows in a db2 table?
What is dbrm in db2 database?
What is the difference between bind and rebind in db2?
What is multi row fetch in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Is db2 a database?
What is db2 stogroup?
Explain packages.
How do I create a view in db2?