Explain transactions, commits and rollbacks in DB2. In DB2 a transaction typically requires a series of updates, insertions and deletions that represent a logical unit of work. A transaction puts an implicit lock on the DB2 data. Programmers can use the COMMIT WORK statement to terminate the transaction creating smaller units for recovery. If the transaction fails DB2 uses the log to roll back values to the start of the transaction or to the preceding commit point.

  • Interview Candidate
  • 0
  • 3097

 

This Question is not yet answered!

 
 

Related Answered Questions

 

Related Open Questions