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. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *