RMUDISPLAY72.HLB  —  Overview  Screens  Lock Timeout History screen
    The Lock Timeout History screen can be used to identify the
    object that causes a timeout event.

    The Stall Messages screen provides stall information, but when
    a process times out while waiting for a lock, the stall is
    terminated and the information is no longer available on the
    Stall Messages screen.

    For each active process on the current VMScluster node, the Lock
    Timeout History screen shows the process ID, the time that the
    process most recently timed out while waiting for a lock, the
    reason for the most recent timeout experienced by the process,
    and the number of timeouts experienced by the process since
    attaching to the database.

    The information shown in the screen includes:

    o  process ID

       The process ID of each active process.

    o  occurred

       The time that the process most recently timed out while
       waiting for a lock. This field is blank if the process has
       not experienced any timeouts.

    o  lock timeout reason

       The event that caused the most recent timeout experienced
       by the process. This field is blank if the process has not
       experienced any timeouts. Note that the lock timeout reason
       does not identify the cause of the timeout. The conflicting
       process could be on a different VMScluster node. Rather, the
       lock timeout reason provides historical information that can
       help the DBA track down the timeout by other means, such as
       using the RMU Show Locks utility or examining the application
       transaction data flow analysis. The lock timeout reason
       remains displayed for a process until the process is involved
       in another timeout or detaches from the database. For more
       information on interpreting the lock timeout reasons, see the
       descriptions for the stall reasons in the help text for the
       Stall Messages screen.

    o  timeout

       The number of timeouts the process has experienced since
       being attached to the database. This field is blank if the
       process has not experienced any timeouts. This information
       may be as useful as the lock timeout reason in determining
       the importance of the timeout. For instance, if the database
       has been active for a week and the number of timeouts is low,
       the system may be operating efficiently. Timeouts are fairly
       common in a database system, and not all timeouts are bad.
Close Help