Global timeout processing

Just as in a non-data-sharing environment, Db2 calculates the timeout period based on the RESOURCE TIMEOUT and DEADLOCK TIME installation parameter values.

Db2 calculates the timeout period as follows:
  1. Divide RESOURCE TIMEOUT by DEADLOCK TIME
  2. Round to the next largest integer
  3. Multiply that integer by DEADLOCK TIME

In non-data-sharing systems, the actual time that a transaction waits on a lock before timing out varies between the timeout period and the timeout period plus one DEADLOCK TIME interval.

For example, if the timeout period for a given transaction is 60 seconds and the DEADLOCK TIME value is 5 seconds, the transaction waits between 60 and 65 seconds before timing out, with the average wait time of 62.5 seconds. This is because timeout is driven by the deadlock detection process, which is activated on a timer interval basis.