Lock_Timeout_Log=file-spec

    Records the last lock timeout message for the processes. There
    is no method to record each lock timeout as it occurs. The lock
    timeout messages are written in human-readable format.

    The header region of the lock timeout log contains three lines:

    o  Line 1 indicates that the RMU Show Statistics utility created
       the log file.

    o  Line 2 identifies the database.

    o  Line 3 identifies the date and time the log was created.

    The main body of the stall log contains three columns:

    o  The first column contains the process ID and stream ID that
       experienced the lock timeout.

    o  The second column contains the time the timeout occurred;
       however, the date is not displayed.

    o  The third column contains the timeout message describing the
       affected resource. This message is similar to the originating
       stall message.

    For example:

    2EA00B52:34 14:25:46.14 - waiting for page 5:751 (PR)

    If any lock timeouts are missed for a particular process (usually
    because the recording interval is too large), the number of
    missed lock timeouts is displayed in brackets after the message.
    For example:

    2EA00B52:34 14:25:46.14 - waiting for page 5:751 (PR) [1 missed]

    Only one message is logged for each lock timeout.

    The lock timeout messages are written at the specified screen
    refresh rate, determined by specifying the Time qualifier, or
    online using the Set_rate on-screen menu option. Using a larger
    refresh rate minimizes the size of the file, but results in a
    large number of missed lock timeout messages. Using a smaller
    refresh rate produces a large log file, but contains a much finer
    granularity of lock timeout messages.

    Using the Time=1 or Time=50 qualifier appears to produce a
    reasonable log while minimizing the impact on the system.

    The affected LockID is not displayed because this is meaningless
    information after the lock timeout has completed.

    Note that you do not need to be displaying the Lock Timeout
    History or Lock Deadlock History screens to record the stall
    messages to the stall log. These logs are maintained regardless
    of which screen, if any, is displayed.

    Use the Tools menu (displayed when you press the exclamation
    point (!) key from any screen) to enable or disable the lock
    timeout and lock deadlock logging facility while the RMU Show
    Statistics utility is running. However, note that the lock
    timeout log and lock deadlock log are not available during binary
    file replay.