DB2 implements optimistic concurrency control by ________.
- Using commit timestamps
- Using locks
- Using row versions
- Using timestamps
DB2 implements optimistic concurrency control by using row versions. In this approach, when a transaction updates a row, it does not acquire locks on the data. Instead, it checks whether any other transaction has modified the row after it was last read. If so, it aborts the transaction, avoiding the need for locking and reducing contention.
Loading...
Related Quiz
- What is the primary objective of denormalization in DB2?
- DB2 Visual Explain aids in optimizing query performance by identifying potential ________.
- Performance tuning in DB2 involves leveraging various ________ features.
- The performance impact of data compression in DB2 depends on the ________.
- What does the Reorg utility do to database objects in DB2?