Interested to Buy Any Domain ? << Click Here >> for more details...
Explain transactions, commits and rollbacks in DB2.
- 3 Answers
- 8343 Views
- I also Faced
- E-Mail Answers
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
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Who uses db2?
What is isolation level in db2?
What is the use of commit in db2?
What is consistency token in db2?
What are the two types of logging in the db2 database? Explain them.
How do we specify index to include or not during bind process.
Why cursor is used in db2?
Are views updateable?
How do you concatenate the firstname and lastname from emp table to give a complete name?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is a trigger in the db2 database?
What is dpf in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Comment whether the cursor is closed during commit or not.
