Viewing a summary of delay statistics
Follow these steps to view a summary of delay statistics.
Procedure
- On the Db2 Query Monitor main menu, type 1 in the Option field and press Enter.
- Select the summary level that you want to view.
- Locate the SQL activity for which you want to view delay information.
-
Type D in the CMD field next to the SQL activity
of interest and press Enter.
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 **********************************