O'Reilly logo

DB2® Universal Database for OS/390® Version 7.1 Certification Guide by Susan Lawson, Richard Yevich

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required