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.

        Locking and Waiting: 
        Type Usr Name       Record    Trans    Schema 
        Lock 999 TOTAL...     2345      567       145 
        Wait 999 TOTAL...       89       12         9 
        Lock   0               654       32        33 
        Wait   0                 0        0         0 
        Lock   1 sue            54        6         3 
        Wait   1 sue             0        0         0 
        Lock   2 dave           43        7         2 
        Wait   2 dave           21        3         2 
        Lock   3              1123      302        54 
        Wait   3                12        1         0 
        Lock   4 mary          345       89        30 
        Wait   4 mary           20        6         0 
        Lock   5 bill          101       20        15 
        Wait   5 bill           10        2         0 
        Lock   6               175       34         0 
        Wait   6                15        3         0 
        RETURN - repeat, U - continue uninterrupted, Q - quit: 

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