Ingres 11.0 | Lockstat Command Output

Command Reference Guide > Command Reference Guide > Using Ingres Commands > lockstat Command--Display Locking Status > Lockstat Command Output

Was this helpful?

Lockstat Command Output

The key items to examine in lockstat output are the waiting statistics, including the following:

• Lock wait in the Locking System Statistics

• Deadlock in the Locking System Statistics

• 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.

Last modified date: 01/30/2023