Kbase 21639: Explanation of the Lock Table flags in promon
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/26/2008 |
|
Status: Verified
GOAL:
Explanation of the Lock Table flags in promon
GOAL:
What does the Lock Table flags in promon mean?
GOAL:
What are the Lock Table flags in promon?
FIX:
In the R&D section of Promon, under Status Displays is one for Lock Table, which is used to display locking information, specifically the types of locks being used.
Most of the lock flags are self-explanatory and easily understood. One flag, H (Hold) has generated questions as to precisely what function it serves and how to interpret it when seen in Promon.
The lock flags used in Promon are as follows:
S Indicates a SHARE Lock
X Is an EXCLUSIVE Lock
U Lock was UPGRADED from a Share to an Exclusive
L Lock is in a LIMBO state. The lock is held until the transaction is committed even though the user has released it.
Q Request for the lock is QUEUED.
User is waiting for a conflicting lock held by another user.
P PURGED. Lock is no longer held.
H HOLD. The lock is in a temporary state during a lock conflict.
When a process is waiting for a lock and has not yet taken ownership of the lock, it is in a HOLD status.
Progress Virtual System Tables may be used to access the same information provided by Promon. In version 9.1C, for example, Lock Table Activity is displayed using _ActLock.