Progress
Database Administration
Guide and Reference


Activity Displays>Lock Table

Displays information about Lock Table Activity. The database engine stores record locks in the lock table. If a user tries to acquire a lock on a record, and the lock table overflows, the server aborts.

Figure A–27 shows a sample Lock Table Activity display.

01/25/02             Activity: Lock Table 
16:24:02             from 01/25/02 15:31 to 01/25/02 16:24 
                                    Total   Per Min   Per Sec    Per Tx 
Share requests                      0       0         0.00       0.00 
Exclusive requests                  0       0         0.00       0.00 
Upgrade requests                    0       0         0.00       0.00 
Rec Get requests                    0       0         0.00       0.00 
Share grants                        0       0         0.00       0.00 
Exclusive grants                    0       0         0.00       0.00 
Upgrade grants                      0       0         0.00       0.00 
Rec Get grants                      0       0         0.00       0.00 
Share waits                         0       0         0.00       0.00 
Exclusive waits                     0       0         0.00       0.00 
Upgrade waits                       0       0         0.00       0.00 
Rec Get waits                       0       0         0.00       0.00 
Requests cancelled                  0       0         0.00       0.00 
Downgrades                          0       0         0.00       0.00 
Redundant requests                  0       0         0.00       0.00 

Figure A–27: PROMON Lock Table Activity Display

The display lists the following operations:


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