2. Using Ingres Commands : lockstat Command—Display Locking Status
 
Share this page                  
lockstat Command—Display Locking Status
Permission required: Installation owner.
The lockstat utility displays locking status information for your Ingres installation. It allows you to examine the state of the Lock Database by providing a summary listing and a snapshot of the installation’s locking activity.
This tool is useful for finding lock contention and concurrency problems. It will help you identify locking bottlenecks so that you can correct the problem by setting lockmode appropriately or by remodeling the application if it is a fundamental design or program flow problem.
Note:  The forms-based ipm utility incorporates the lockstat functions.
The lockstat command has the following format:
lockstat [-summary | -statistics | -lists | -user_lists |
-special_lists | -resources | -dlm | -dlmall | -dirty | -help]
lockstat
Displays all reports. This is the default.
-summary
Displays locking system summary
-statistics
Displays locking system summary, statistics, statistics by lock type
-lists
Displays locks by lock list (user and special)
-user_lists
Displays locks by lock list (user)
-special_lists
Displays locks by lock list (special, that is, "NONPROTECT")
-resources
Displays locks by resource
-dlm
Displays the cluster DLM (Distributed Lock Manager) view of locks (grouped by resource) that have one or more waiters. The -dlm and -dlmall options are available only in releases that support clusters and when Ingres is configured for such support.
Note:  When running in an installation configured with cluster support, lockstat output is the same as the non-cluster lockstat but with the -dlm output appended to the end.
-dlmall
Displays the same information as lockstat -dlm, but for all locks in the installation (that is, including those that do not have locks in a wait or convert status)
-dirty
Displays the requested information without waiting for mutexes. Using the -dirty option means the information displayed may be out of date or inconsistent.
-help
Displays command options online