How does DB2 handle deadlock situations during monitoring and troubleshooting?

  • DB2 automatically resolves deadlocks by rolling back the least expensive operation
  • DB2 employs a timeout mechanism to break deadlocks
  • DB2 notifies the administrator and allows manual intervention to resolve deadlocks
  • DB2 uses a deadlock detection algorithm
DB2 uses a deadlock detection algorithm that detects when two or more transactions are waiting for locks held by each other, and it resolves these deadlocks by rolling back one of the transactions involved. Deadlocks are detected by DB2 automatically. 
Add your answer
Loading...

Leave a comment

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