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
How to find schema of a table in db2?
How and when does the db2 enforces the unique key?
What are the full forms of spufi and dclgen and why are they used?
How do I add a column to an existing table in db2?
How do you stop a db2 database in linux?
What is db2 instance?
Can we delete records from view?
What is a system catalog table in db2?
What is cursor stability in db2?
Who uses db2?
What is a trigger in the db2 database?
What is db2 stogroup?
What db2 400?
What is the physical storage length of timestamp data type?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?