Try OpenEdge Now
skip to main content
Database Administration
Reference : PROMON Utility : PROMON Locking and Waiting statistics option
 

PROMON Locking and Waiting statistics option

Displays lock and wait information for each database process. The first two lines display cumulative statistics (since the broker started) for all users.

Sample output for PROMON Locking and Waiting statistics option

The following shows an example of this option's output.
Locking and Waiting:
Type   Usr:Ten   Name     Domain     Record     Trans     Schema
Lock 99999       TOTAL...               864         0          0
Wait 99999       TOTAL...                11         0          0
Lock     0:0     dba                      0         0          0
Wait     0:0     dba                      0         0          0
Lock     5:1     tenant1   tenant1       12         0          0
Wait     5:1     tenant1   tenant1        0         0          0
Lock     6:3     lobtenant lobtenant     12         0          0
Wait     6:3     lobtenant lobtenant      0         0          0
Lock     7:2     tenant2   tenant2       15         0          0
Wait     7:2     tenant2   tenant2        0         0          0
Lock     8:4     lobtenant lobtenant     13         0          0
Wait     8:4     lobtenant lobtenant      0         0          0
Lock     9:0     dba                      0         0          0
Wait     9:0     dba                      0         0          0

RETURN - show remaining, U - continue uninterrupted, Q - quit:
Type
Lock or Wait. The output display includes two lines for each process. The first shows the number of record, transaction, and schema locks obtained, and the second shows the number of times the process waited to obtain one of these locks.
Usr:Ten
The user number and tenant ID of the process. User number 999 represents all users.
Name
For client processes, the user name.
Domain
The user's domain name.
Record
For the Lock type, the total number of record locks obtained. For the Wait type, the number of times the user had to wait to obtain a record lock. Numbers are cumulative for the life of the process.
Trans
For the Lock type, the number of times a transaction lock was issued. A transaction lock is issued for the duration of a transaction when a record is deleted. If the transaction is ultimately undone or backed out, the record is not deleted.
For the Wait type, the number of times the user had to wait before accessing or skipping a record marked for deletion by an unfinished transaction. This transaction wait corresponds exactly to the TSK wait described under User Control (option 1).
Schema
For the Lock type, the total number of times the schema lock was obtained. For the Wait type, the number of times the user had to wait to obtain the schema lock. (There is one schema lock; only one user at a time can update any part of the schema.)