How to use PROMON to determine which records are being locked by a user?

How to use PROMON to determine which records are being locked by a user?

What records are being locked in a database, the Types of locks and user information associated with these records can be found in PROMON menus.

To identify locked records:

1.  Start PROMON against the online database 2.  Select Option 4. Record Locking Table from the Main Menu
3. Select the Option needed from the Record Locking Table Menu:
 
Example output from selecting Option 1. Display all entries:

Output for Progress 9.x - OpenEdge 10.2A

Record Locking Table:

Usr   Name    Chain #  Rec-id  Table Lock Flags
5     <userid> REC100      98      2        SHR

Output for OpenEdge 10.2B and later:

Record Locking Table: by user number for all tenants                                
Usr:Ten    Name  Domain Chain #  Rowid Table:Part  Lock Flags   Tran  State  Tran ID
  5     <userid>     -3 REC   99    97          2         SHR  Begin    FWD    27954


5  To map the table number to a table name, run following ABL query:
 

FOR EACH _file WHERE _file._file-number = <number> NO-LOCK.
   DISPLAY _file._file-number _file._file-name.
END.