Deadlock_Log=file-spec

    Records the last deadlock for the processes. There is no method
    to record each lock deadlock as it occurs.

    The file-spec in the qualifier is the name of the file to which
    you want all lock deadlock messages to be logged. The lock
    deadlock messages are written in human-readable format similar
    to the Lock Timeout History and Lock Deadlock History screens.

    The header region of the lock deadlock 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 deadlock.

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

    o  The third column contains the deadlock 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 deadlocks are missed for a particular process
    (usually because the recording interval is too large), the
    number of missed lock deadlocks 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 deadlock.

    The lock deadlock 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 deadlock messages. Using a smaller
    refresh rate produces a large log file, but contains a much finer
    granularity of deadlock messages.

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

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

    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.