Displays information about lock requests, organized by user.

PROMON Lock Requests by User display

The following shows a sample Lock Requests by User display.

09/25/03        Lock Requests by User
16:19

Usr:Ten   User   Domain  --- Record ---   ---- Trans ---    ---- Schema ---
          Name           Locks    Waits   Locks    Waits    Locks     Waits
  0:0   SYSTEM        0      0        0       0        0        0         0
  5:0  shannon        0      0        0       0        0        0         0
  6:ST  st_bus        1      0        0       0        0        0         0

This display shows the following information:

• Usr:Ten — The user number and tenant
• User Name — The user name
• Domain — The domain of the user
• 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 — The number of times a deleted record is protected until transaction end
• Trans Waits — The number of times a user had to wait for a record marked for deletion by an active transaction
• 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