lockstat/iilockstat Command--Display Locking Status
The lockstat command displays the locking status of a Vector installation. Any user can run this command but requires the database server to be up and running.
The iilockstat command is similar to the lockstat command, with the restriction that it can be run only by an installation owner and does not require the database server to be operational. For future releases, it is planned that it can be run only by the installation owner. Currently, there is no restriction but this is subject to change.
The lockstat/iilockstat command allows you to examine the state of the lock database by providing a summary listing and a snapshot of the installation’s locking activity. It is also useful for identifying lock contention, concurrency problems and lock bottlenecks. These issues can be resolved by setting the lockmode or remodeling the application if it is a fundamental design or program flow problem.
Note: The lockstat/iilockstat functions are included in the forms-based Interactive Performance Monitor (ipm) utility. For more information, see the Interactive Performance Monitor User Guide. You can also monitor log information using Actian Director.
The lockstat/iilockstat command has the following format:
lockstat/iilockstat [-summary] [-statistics] [-lists] [-user_lists]
[-special_lists] [-resources] [-dirty] [-help]
lockstat/iilockstat
Displays all reports. This is the default.
-summary
Displays locking system summary
-statistics
Displays locking system summary and 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
-dirty
Displays the requested information without waiting for mutexes. Using the -dirty option means the information displayed may be outdated or inconsistent.
-help
Displays the command options online
Last modified date: 12/19/2024