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:
Divide RESOURCE TIMEOUT by DEADLOCK TIME.
Round the result up to the next largest integer.
Multiply this integer by the DEADLOCK TIME.
Multiply the result by the appropriate factor.
| Component | Factor | Notes |
|---|---|---|
| Transaction ... |
Get DB2® Universal Database for OS/390® Version 7.1 Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
