Locking Issues and Problems

There are times when too much locking can be a problem. This possibly can result in suspensions, timeouts, or even deadlocks. We will take a look at how these situations can occur.

Timeouts and Deadlocks

While waiting for a lock, a process can exceed an allowable amount of wait time that has been established. A system-wide option determines the maximum time a process can wait before it gets a resource unavailable error. This value is called the resource timeout value and is calculated by the following formula:

  1. Divide RESOURCE TIMEOUT by DEADLOCK TIME.

  2. Round the result up to the next largest integer.

  3. Multiply this integer by the DEADLOCK TIME.

  4. Multiply the result by the appropriate factor.

ComponentFactorNotes
Transaction ...

Get DB2® Universal Database for OS/390® Version 7.1 Certification Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.