Release 10.1A: OpenEdge Data Management:
Database Administration

> ## Lock Requests by User

> Displays information about lock requests, organized by user. Figure 19–46 shows a sample Lock Requests by User display.

>     09/25/03        Lock Requests by User
>     16:19
>     Usr   User   --- Record ---   ---- Trans ---    ---- Schema ---
>     Num   Name   Locks    Waits   Locks    Waits    Locks     Waits
>       0   SYSTEM     0        0       0        0        0         0
>       5   rgw        0        0       0        0        0         0
>       6              0        0       0        0        0         0
>       7           3625        0       0        0        0         0

> Figure 19–46: PROMON Lock Requests by User display

> This display shows the following information:

> - Usr Num — The user number.

> - User Name — The user name.

> - Record Locks — The number of records locks acquired by the user.

> - Record Waits — The number of times the user had to wait for a record lock.

> - Trans Locks — Not currently implemented.

> - Trans Waits — The number of times the user had to wait for a record lock.

> - Schema Locks — The number of schema locks acquired by the user.

> - Schema Waits — The number of times the user had to wait for a schema lock.

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