Progress
Database Administration
Guide and Reference
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. Figure 19–5 shows an example of this option’s output.
Figure 19–5: Sample Output For PROMON Locking and Waiting Statistics Option
DISPLAY FIELDS
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
The user number of the process. User number 999 represents all users.
Name
For client processes, the user 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.)
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |