Serialization Delay Report Summary Section
The Serialization Delay Report Summary Section provides system-wide summary data and values. The Summary section is produced when REPORT=SUMMARY is specified on the SERDELAY statement.
The data is presented in three subsections for each lock type:
- System Locks (including CSML and CSSL)—presents system suspend lock summary data.
- GRS Latch—presents GRS latch summary data.
- GRS Enqueue—presents GRS enqueue request summary data.
The Serialization Delay Report Summary Section provides the following values for each lock type:
- number of units of work suspended
- number of units of work suspended while the suspended queue length is > 1
- total time that one or more units of work was suspended
- average time that a unit of work was suspended
- standard deviation of the total contention time
The following figure displays a sample of the Serialization Delay Report Summary Section.
OPTIONS : REPORT=(SUMMARY,DETAIL),SELECT=(ALL),ZERO=NO
--------------------------------------------------------- SUMMARY SECTION -----------------------------------------
----------------------------------------------------------- SYSTEM LOCKS ------------------------------------------
LOCK TYPE --- SUSPENDED --- -- TIME (SECS) -- LOCK TYPE --- SUSPENDED --- -- TIME (SECS) --
----------- TOTAL QLEN >1 TOTAL AVERAGE ----------- TOTAL QLEN >1 TOTAL AVERAGE
CMS LOCK 2,449 113 0.998 0 CMS SMF 446 295 0.414 0.001
CMS ENQ/DEQ 2,065 25 0.313 0 LOCAL 573,642 120,704 70.391 0
CMS LATCH 0 0 0 0 CML OWNER 33,757 2,971 6.756 0
GRS ----------------- GRS LATCH ----------------- ---------------------- GRS ENQUEUE ---------------------
MODE SUSPENDED ------- TIME (SECS) ------ SCOPE --- REQUESTS ---- ------- TIME (SECS) ------
---- TOTAL TOTAL AVERAGE STD.DEV ------- TOTAL SUSPENDED TOTAL AVERAGE STD.DEV
RING OBTAIN 765 2.059 0.003 0.022 STEP 895,101 7,947 2.198 0 0.002
SYSTEM 489,340 610 1.168 0.002 0.022
SYSTEMS 2,577 93 24.901 0.268 0.349
The following table describes the Serialization Delay Report Summary Section fields.
Field | Description |
|---|---|
System locks | |
LOCK TYPE | identifies each type of system lock presented in the report Possible system lock types are:
|
TOTAL SUSPENDED | total number of times that a unit of work was suspended |
QLEN > 1 SUSPENDED | total number of times that a unit of work was suspended while one or more other units of work were already suspended |
TOTAL TIME (SECS) | total amount of time, in seconds, that a unit of work was suspended |
AVERAGE TIME (SECS) | average amount of time, in seconds, that a unit of work was suspended |
GRS Latch | |
GRS MODE | GRS mode of operation Possible values are:
|
OBTAIN | values that pertain to OBTAIN requests |
TOTAL SUSPENDED | total number of times that a unit of work was suspended |
TOTAL TIME (SECS) | total amount of time, in seconds, that a unit of work was suspended |
AVERAGE TIME(SECS) | average amount of time, in seconds, that a unit of work was suspended |
STD.DEV TIME(SECS) | standard deviation of the total suspended time, in seconds |
GRS Enqueue | |
SCOPE | scope of a GRS enqueue request Values are:
|
TOTAL REQUESTS | total number of GRS enqueue requests |
SUSPENDED REQUESTS | total number of times that a unit of work was suspended |
TOTAL TIME (SECS) | total amount of time, in seconds, that a unit of work was suspended |
AVERAGE TIME (SECS) | average amount of time, in seconds, that a unit of work was suspended |
STD.DEV TIME (SECS) | standard deviation of the total suspended time, in seconds |
Related topic