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.
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.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |