Previous Topic: Interpret SCS StatisticsNext Topic: Interpret cluster-wide CI, NI, and Adapter Statistics

Evaluate Performance in Detail › Performance Evaluation Report › Interpret cluster-wide Lock Statistics

Interpret cluster-wide Lock Statistics

The lock statistics are the first cluster-wide statistics, and follow the system-specific SCS statistics. To display only the lock statistics section of the Performance Evaluation Report, use this qualifier:

/INCLUDE=LOCK_STATISTICS

To disable the lock statistics display from the report, use this qualifier:

/INCLUDE=NOLOCK_STATISTICS

The following example shows the lock statistics section of the Performance Evaluation Report:

Performance                          CLUSTER                            Page  14
Evaluation                                                          PA Vx.x
					Wednesday 14-JAN-2006 00:00 to 12:16

  +-----------------------------------------------------------------------+
  | The following table gives a summary of the average amount of lock     |
  | traffic per second in the cluster                                     |
  +-----------------------------------------------------------------------+

         Local       Incoming     Outgoing      Waiting   LOCK-  Deadlk  Deadlk
Node     ENQ/CVT/DEQ ENQ/CVT/DEQ  ENQ/CVT/DEQ    locks    DIRWT   find   search
-------- ----------- -----------  -----------   -------   -----  ------  ------
   1          2           3           4             5       6       7      8
NODE01   24/ 23/ 24  13/  3/ 13/  0/  1/  0/        0       2       0      0
-------  --- --- --- --- --- ---  --- --- ---      ---             ---    ---
Total    24/ 23/ 24  13/  3/ 13/  0/  1/  0/        0               0      0

The following statements are keyed to the columns in previous example:

  1. Each node in the cluster.
  2. Average enqueue (ENQ), conversion (CVT), and dequeue (DEQ) lock requests per second for locks that are managed by the node requesting the lock. An enqueue lock request queues a new lock resource. A conversion lock request occurs when a lock of one mode has already been granted and a lock request to change the lock mode is to be granted. A dequeue lock request releases the granted lock.
  3. Average lock requests per second for locks that are managed by the local node but originate on other nodes.
  4. Average lock requests per second for locks that originate on a local node but are managed by other nodes.
  5. Average number of ENQ lock requests per second that had to wait in the wait queue.
  6. Value of the SYSGEN parameter LOCKDIRWT on each respective node.
  7. Deadlock detections per second during the reporting period.
  8. Deadlock searches per second during the reporting period.