LockQueueCheckInterval

Integer (milliseconds)

1000

Purpose

The LockQueueCheckInterval parameter specifies the time interval in which the server node checks if lock entries have timed out. Use this parameter in conjunction with the ServerTimeout parameter.

Parameter is read when …

The database server node is next initialized.

Hints

Set this parameter to a low number if you want prompt notification of locked resources or to a larger number if your need to know is not so great.

The smaller the interval, the greater the processor overhead on the server nodes.

Queued lock requests are checked for timeout at the interval specified by this parameter. With the default value of 1,000 milliseconds, there can be a delay of up to 1 second between when the lock timeout time is reached and when the timeout is detected, and an exception is raised. If you need the timeout to cause an exception in a shorter time than this, set this parameter to the appropriate value.