Delay statistics - fields (ISPF)

This topic describes the statistics that are displayed on the Delay Statistics panel.

Lock or Latch Delays
The accumulated lock and latch elapsed wait time for lock and latch suspensions.
Offload table name
CQM_SUMM_METRICS
Column name
LOCK_LATCH_DLY
Synchronous I/O Delays
The accumulated elapsed wait time for I/O. Synchronous I/O delays are further broken-down into Database I/O Delays and Log Write I/O Delays
Offload table name
CQM_SUMM_METRICS
Column name
SYNC_IO_DLY>
Database I/O Delays
The accumulated I/O elapsed wait time for database I/O. This value is calculated as follows: (Sync I/O Delay) / (Sync I/O Events).
Offload table name
not applicable
Column name
not applicable
Log Write I/O Delays
The accumulated elapsed wait time for log write I/O. This value is calculated as follows: (Log Write I/O Delay) / (Log Write I/O Events)
Offload table name
not applicable
Column name
not applicable
Other Read Delays
The accumulated wait time for read I/O.
Offload table name
CQM_SUMM_METRICS
Column name
OTHER_READ_DLY
Other Write Delays
The accumulated wait time for write I/O.
Offload table name
CQM_SUMM_METRICS
Column name
OTHER_WRITE_DLY
Service Task Switch Delays
The accumulated wait time due to synchronous execution unit switch to Db2® services.
Offload table name
CQM_SUMM_METRICS
Column name
SERVTASK_SW_DLY
Update Commit Delays
The Db2® service waits for UPDATE COMMITs.
Offload table name
not applicable
Column name
not applicable
Open/Close Delays
The Db2 service waits for OPEN/CLOSE DATASET.
Offload table name
CQM_SUMM_METRICS
Column name
OPEN_CLOSE_DLY
SYSLGRNG Rec Delays
The Db2 service waits for SYSLGRNG UPDATE.
Offload table name
CQM_SUMM_METRICS
Column name
SYSLOG_REC_DLY
EXT/DEL/DEF Delays
The Db2 service waits for EXTEND DATASET, DELETE DATASET, and DEFINE DATASET.
Offload table name
CQM_SUMM_METRICS
Column name
EXTDEL_DEF_DLY
Other Service Delays
The Db2 service waits for HSM RECALL DATASET and DATASPACE MANAGER SERVICES.
Offload table name
CQM_SUMM_METRICS
Column name
OTHER_SERVE_DLY
Archive Log Quiesce Delays
The accumulated wait time for archive log quiesces.
Offload table name
CQM_SUMM_METRICS
Column name
ARCHLOG_QS_DLY
Archive Log Read Delays
The accumulated wait time for archive log reads.
Offload table name
CQM_SUMM_METRICS
Column name
ARCHLOG_RD_DLY
Drain Lock Delays
The accumulated wait time for drain locks.
Offload table name
CQM_SUMM_METRICS
Column name
DRAIN_LOCK_DLY
Claim Release Delays
The accumulated wait time for claim releases.
Offload table name
CQM_SUMM_METRICS
Column name
CLAIM_REL_DLY
Page Latch Delays
The accumulated wait time due to page latch contention.
Offload table name
CQM_SUMM_METRICS
Column name
PAGE_LATCH_DLY
Stored Procedure Delays
The accumulated wait time due to stored procedure contention.
Offload table name
CQM_SUMM_METRICS
Column name
SP_DLY
UDF Schedule Delays
The accumulated wait time for scheduling user defined functions.
Offload table name
CQM_SUMM_METRICS
Column name
UDF_SCHED_DLY
Notify Message Delays
The accumulated wait time due to notify messages.
Offload table name
CQM_SUMM_METRICS>
Column name
NOTIFY_MSGS_DLY
Global Contention Delays
The accumulated elapsed wait time due to global contention for parent L-LOCKS.
Offload table name
CQM_SUMM_METRICS
Column name
GLOBAL_CONT_DLY
Lock Requests - PLOCKS
The accumulated wait time due to parent object locks (database, table space, table, partition).
Offload table name
CQM_SUMM_METRICS
Column name
LOCK_REQ_PLOCKS
L-Locks Child (PAGE,ROW)
The accumulated wait time due to child object locks (pages, rows).
Offload table name
CQM_SUMM_METRICS
Column name
LLOCKS_CHILD_DLY
L-Locks Other
The accumulated wait time not due to child or parent object locks.
Offload table name
CQM_SUMM_METRICS
Column name
LLOCKS_OTHER_DLY
P-Locks Pageset/Partition
The accumulated wait time due to physical locks for pagesets or partitions.
Offload table name
CQM_SUMM_METRICS
Column name
PLOCKS_PAGESET_DLY
P-Locks Page
The accumulated wait time due to page contention.
Offload table name
CQM_SUMM_METRICS
Column name
PLOCKS_PAGE_DLY
P-Locks Other
The accumulated wait time for other physical contention.
Offload table name
CQM_SUMM_METRICS
Column name
PLOCKS_OTHER_DLY
Commit Phase 1 Write IO Delays
The accumulated wait time due to child object locks (pages, rows).
Offload table name
CQM_SUMM_METRICS
Column name
LLOCKS_CHILD_DLY
Asynch CF Requests Delays
The accumulated wait time for IXLCACHE and IXLFCOMP asynchronous requests.
Offload table name
CQM_SUMM_METRICS
Column name
ASYNCH_CFREQ_DLY
Total Delays
The total accumulated wait time due to all delays.
Offload table name
not applicable
Column name
not applicable