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
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How do I import data from excel to db2?
What is the maximum number of columns in a db2 table?
What is precompiler in db2?
What is the role of schema in the db2 database?
How do I import a csv file into db2?
What is commit in db2?
What are the 2 sqlcodes that are returned?
Explain dclgen.
How do you simulate the explain of an embedded sql statement in spufi/qmf?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
When reorg is used?
What is cursor stability in db2?
Explain about open switch business continuity software?
What is table space in db2?