Lock Requests by User

Database Administration

Reference : PROMON Utility : R&D Other Displays : Lock Requests by User

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