Viewing delay statistics for current activity
You can view delay statistics for current SQL activity.
Procedure
To view delay statistics for current activity:
- On the IBM DB2 Query Monitor for z/OS panel (the main menu), type 3 in the Option field, and press Enter.
- Locate the SQL activity for which you want to view delay statistics.
-
Type D in the CMD field next to the SQL activity of interest, and
press Enter.
The Delay Statistics panel is displayed:
Figure 1. Delay Statistics panel YYYY/MM/DD HH:MM:SS --------- Delay Statistics --------- Row 1 of 30 Option ===> ________________________________________________ Scroll ===> PAGE NAVI: DB2(ST):DB01 ------------------------------------------------------------------------ Delay Event Event Count Delay Time Lock or Latch Delays 0 0.000000 Synchronous I/O Delays 11,260 20.285012 Database I/O Delays 10,635 20.033022 Log Write I/O Delays 625 0.251989 Other Read Delays 11 0.047683 Other Write Delays 0 0.000000 Service Task Switch Delays 5,231 23.957937 Update Commit Delays 0 0.000000 Open/Close Delays 2,475 19.004652 SYSLGRNG Rec Delays 160 0.039277 EXT/DEL/DEF Delays 2,507 4.793309 Other Service Delays 89 0.120698 Archive Log Quiesce Delays 0 0.000000 Archive Log Read Delays 0 0.000000 Drain Lock Delays 0 0.000000 Claim Release Delays 0 0.000000 Page Latch Delays 0 0.000000 Stored Procedure Delays 0 0.000000 UDF Schedule Delays 0 0.000000 Notify Message Delays 1,385 0.310889 Global Contention Delays 0 0.000000 L-Locks Parent (DB,TS,TAB,PART) 0 0.000000 L-Locks Child (PAGE,ROW) 0 0.000000 L-Locks Other 0 0.000000 P-Locks Pageset/Partition 0 0.000000 P-Locks Page 0 0.000000 P-Locks Other 0 0.000000 Commit Phase 1 Write IO Delays 0 0.000000 Asynch CF Requests Delays 0 0.000000 Total Delays 17,887 44.601523 ***************************** Bottom of Data **********************************