Release 10.1A: OpenEdge Data Management:
Database Administration

> ## Lock Table

> Displays status information about the lock table. For a description of the lock table and its functions, see Chapter 13, " Managing Performance." When you choose this menu option, PROMON gives you three choices:

> - Display all lock entries.

> - Display locks for one user.

> - Display locks for one RECID.

> Figure 19–21 shows a sample Lock Table Status display.

>     11/01/035        Status: Lock Table
>     16:22
>     Usr Name     Trans id Type Table    RECID Flags         Trans State
>     8    rgw     0         REC       -6   2592  S     L       Begin
>     8    rgw     0         REC       -67  6818  S     L       Active

> Figure 19–21: PROMON Lock Table Status display

> The display contains the following fields:

> - Usr — The user number of the user who owns the lock entry.

> - Name — The user name.

> - Trans id — The transaction id.

> - Type — The lock type (for example, REC, RGET).

> - Table — The table number.

> - RECID — The RECID of the record and lock table entry.

> - Flags — Table 19–12 lists the possible flags.

> Table 19–12: Lock table flags
> Flag | Description
> --- | ---
> S | Share lock.
> X | Exclusive lock.
> U | Lock was upgraded from a share lock to an exclusive lock.
> L | Limbo. Lock is being held until the transaction commits.
> Q | Request is queued, and the user is waiting for a conflicting lock held by another user.
> P | Purged.
> H | Hold.

> - Trans State — Indicates the state of the transaction.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095