2. Using Ingres Commands : lockstat Command—Display Locking Status : Lockstat Command Output – Locking System Summary
 
Share this page                  
Lockstat Command Output – Locking System Summary
The Locking System Summary portion of the sample output is a summary listing of locking quotas for the installation. All values are cumulative from the time ingstart was run for this iteration of the system.
Here is sample output from this section:
=======Mon Mar 29 13:34:06 2010    Locking System Summary=======
  Total Locks          19500  Total Resources     13000
  Locks per transaction                             750
  Lock hash table       2593  Locks in use           10
  Resource hash table   2593  Resources in use        8
  Total lock lists       286  Lock lists in use      41
Fields are as follows:
Total locks
Maximum number of locks in the installation. Its value is the lock_limit value multiplied by 1.5.
Total Resources
Maximum number of lockable resources in the installation
Locks per transaction
Maximum number of locks that may be acquired by a transaction
Lock hash table
Number of hash buckets in the locking system hash table
Locks in use
Number of locks currently in use in the installation
Resource hash table
Number of hash buckets in the resource hash table
Resources in use
Total number of countable resources in use
Total lock lists
Maximum number of lock lists available
Lock lists in use
Number of lock lists currently in use