2. Using Ingres Commands : lockstat Command—Display Locking Status : Lockstat Command Output
 
Share this page                  
Lockstat Command Output
The key items to examine in lockstat output are the waiting statistics, including the following:
Lock wait in the Locking System Summary
Deadlock in the Locking System Summary
Wait in the Locks by Lock List
Status WAIT in the Locks by Lock List
Note:  The lockstat command gives detailed statistics on all locking activity in the installation, so if there is much activity, the quantity of output will be considerable.