Workload Highlight

This block shows the highlights of the workload activity performed by the event. All workload fields available in the SORTBY option are included.

Workload Highlights (HILITE) Block Example

Here is an example of the workload highlight (HILITE) block.

      --- WORKLOAD HILITE ----------------------------------------------------------------------------------------------------------
      SCANS   :     8  RECS/SORT:  3.00  I/O REQS:        1  SUSPENDS   :        2  EXITS    :        2  AMS              :        1
      ROWSPROC:     8  WORK/SORT:  2.00  AET/I/O : 1.374752  AET/SUSP   : 0.485483  AET/EXIT : 0.048234  AET/AMS          : 0.094745
      PAGESCAN:    47  PASS/SORT:  2.00  DATACAPT:      YES  RIDS UNUSED:        2  CHECKCON : REJECTED  DEGREE REDUCTION :        3
      LOB_PAGSCAN:    12345          LOB_UPD_PAGE:    12345

Field description

Here is a description of the field labels shown in the workload highlight (HILITE) block.
SCANS
The total number of scans performed by the data manager.
RECS/SORT
The average number of records per sort.
I/O REQS
The number of SYNCHRONOUS and ASYNCHRONOUS READ and SYNCHRONOUS WRITE I/O requests per event.
SUSPENDS
The number of LOCK SUSPENSIONS per event.
EXITS
The number of validation, encode edit, and decode edit exits per event.
AMS
The number of times Access Method Services (AMS) was invoked within the event. AMS can be invoked by:
  • Creating a Db2® page set (table space, table partition, index space)
  • Expanding an existing Db2 page set
  • Deleting a Db2 page set
ROWSPROC
The number of rows processed (of all record types).
WORK/SORT
The average number of work files per sort.
AET/I/O
The average elapsed time I/O requests.
AET/SUSP
The average elapsed time for LOCK SUSPENSIONS.
AET/EXIT
The average elapsed time per EXIT invocation.
AET/AMS
The average elapsed time of the AMS invocations within the event.
PAGESCAN
The number of pages scanned.
DATACAPT
The data capture indicator; shows whether IFCID 188 is present.
RIDS UNUSED
The number of times RID list processing was not used because nor RID storage was available or the number of RIDs exceeded the maximum limit.
CHECKCON
Indicates that a table check constraint was performed for the current SQL event:
OK
The check constraint was ok.
REJECTED
The row to be inserted or updated was rejected due to a check constraint.
N/P
No check was performed.
DEGREE REDUCTION
The difference between planned and negotiated run time degree.
LOB_PAGSCAN
The number of LOB pages scanned.
LOB_UPD_PAGE
The number of LOB pages updated.
SYSPLEX QUERY PARALLELISM USED
This field is shown if the query is executed on more than one member, this field shows the number of members. Otherwise this field is blank.
Note:
  1. All fields in the highlight block are printed. If other detail blocks are requested, then some of the highlights are shown twice, once in the highlight block and again in the detail block.
  2. If the records required for a field are not present, N/P is printed for that field. N/A is printed if the field is not relevant to the level of Db2.