Progress
Database Administration
Guide and Reference


PROMON Record Locking Table Option

Displays the contents of the record locking table. Each line corresponds to an entry in the locking table. The lock table contains entries for all record locks currently granted or requested by users of the database. Figure 19–7 shows an example of this option’s output.

Record Locking Table: 
Usr Name      Chain #       Rec-id Lock Flags 
  1 sue       REC   1         5439 SHR        
  1 sue       REC   3         5874 EXCL     Q 
  2 dave      REC   0         5568 EXCL       
  2 dave      REC   2         6002 SHR      L 
  2 dave      REC   3         5939 SHR        
  2 dave      REC   8         5736 SHR      P 
  3           REC   2         4873 EXCL       
  3           REC   3         5238 SHR      U 
  4 mary      REC   0         5293 SHR        
  4 mary      REC   3         4247 SHR        
  4 mary      REC   6         3984 SHR        
  5 bill      REC   1         6324 EXCL       
  5 bill      REC   2         3746 SHR      P 
  5 bill      REC   4         5233 NOLK       
  5 bill      REC   6         5683 EXCL       
  5 bill      REC   9         4832 SHR        
  5 bill      REC  11         5293 SHR        
RETURN - repeat, U - continue uninterrupted, Q - quit 

Figure 19–7: Sample Output For PROMON Record Locking Table Option

The size of the record locking table is set with the Locking Table Entries (-L) startup parameter. See the chapter on locks in the Progress Programming Handbook for more information on locks and locking.

DISPLAY FIELDS
Usr

The user number.

Name

For client processes, the user name.

Chain

The chain type should always be REC, the record lock chain.

#

The record lock chain number. The locking table is divided into chains anchored in a hash table. These chains provide for fast lookup of record locks by Rec-id.

Rec-id

The record ID for the lock table entry. The Rec-id column identifies the records locked by each database process.

Table

The ID of the locked table.

Lock

One of five lock types: X (exclusive lock), S (share lock), IX (intent exclusive lock), IS (intent sharelock), or SIX (shared lock on table with intent to set exclusive locks on records).

Flags

There are five possible types of flags: L, P, Q, or U. Table 19–4 lists the flags and their meanings.

Table 19–4: Flag Values 
Flag
Name
Description
L
Limbo lock
The client has released the record, but the transaction has not completed. The record lock is not released until the transaction ends.
P
Purged lock entry
The lock is no longer held.
Q
Queued lock request
Represents a queued request for a lock already held by another process.
U
Upgrade request
The user has requested a lock upgrade from SHARE to EXCLUSIVE but is waiting for another process that holds a conflicting lock.
H
No hold
The “nohold” flag is set.


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