I/O activity summary report

The I/O activity summary report provides an overview of system-wide I/O activity.

The I/O activity summary report:
  • Summarizes the information contained in the I/O activity detail reports for a location (refer to I/O activity detail report).
  • Shows on a single page a block of entries for each of the I/O categories: buffer pool, EDM pool, active log, archive log/BSDS, and cross invalidation (XI).
  • Is produced if you specify the IOACTIVITY(REPORT) command and there is at least one I/O activity IFCID begin/end pair in the input data set satisfying the FROM and TO, and INCLUDE or EXCLUDE criteria. You do not have to specify the SUMMARY level because this is the default.
The following command produces the I/O activity summary report shown below:
 
IOACTIVITY
     REPORT
 
Figure 1. Sample I/O activity summary report
LOCATION: RS22ODS5                         IBM Z OMEGAMON AI FOR DB2 (V6R1M0)             PAGE: 1-1                  
       GROUP: ODS5                              I/O ACTIVITY REPORT - SUMMARY                    REQUESTED FROM: NOT SPECIFIED        
      MEMBER: OCA5                                                                                           TO: NOT SPECIFIED        
   SUBSYSTEM: OCA5                                                                                INTERVAL FROM: 02/28/19 11:20:21.31 
 DB2 VERSION: V12                                                                                            TO: 02/28/19 11:21:58.70 
0                                                                                      CT/PT/DBD    NOT IN               AVG LEN      
 BUFFER POOL                     TOTALS       AET        EDM POOL                     REFERENCES  EDM POOL        AET    (BYTES)      
 ----------------------------  -------- ---------        ---------------------------  ----------  --------  ---------  ---------      
0TOTAL I/O REQUESTS              145806  0.000414        CURSOR TABLE - HEADER                 0         0        N/C       0.00      
                                                         CURSOR TABLE - DIRECTORY              0         0        N/C       0.00      
 TOTAL READ I/O REQUESTS         145806  0.000414        CURSOR TABLE - RDS SECTION            0         0        N/C       0.00      
   NON-PREFETCH READS               604                  -- TOTAL PLANS -----                  0         0        N/C       0.00      
     ZHYPERLINK                     298                                                                                               
     DISK CACHE HIT                 303                                                                                               
   PREFETCH READS                                                                                                                     
     WITHOUT I/O                      1                  PACKAGE TABLE - HEADER                0         0        N/C       0.00      
     WITH I/O                    145201                  PACKAGE TABLE - DIRECTORY             0         0        N/C       0.00      
     PAGES READ                 4644007                  PACKAGE TABLE - RDS SECTION           0         0        N/C       0.00      
     PAGES READ / SUCC READ       31.98                  -- TOTAL PACKAGES --                  0         0        N/C       0.00      
0TOTAL WRITE REQUESTS                 0       N/C        DATABASE DESCRIPTORS                  0         0        N/C       0.00      
   SYNCHRONOUS WRITES                 0       N/C                                                                                     
    COUPLING FACILITY CASTOUTS        0       N/C                                                                                     
    PAGES WRITTEN PER WRITE        0.00                                                                                               
   ASYNCHRONOUS WRITES                0       N/C                                                                                     
    COUPLING FACILITY CASTOUTS        0       N/C                                                                                     
    PAGES WRITTEN PER WRITE        0.00                                                                                               
-ACTIVE LOG              TOTALS       AET      ARCHIVE LOG              TOTALS       AET      BOOTSTRAP DATASET      TOTALS       AET 
 --------------------- -------- ---------      ---------------------- -------- ---------      -------------------- -------- --------- 
0TOTAL WAITS                 48  0.000294                                                     TOTAL WAITS                 0       N/C 
0READ REQUESTS                0       N/C      READ REQUESTS                 0       N/C      READ REQUESTS               0       N/C 
                                                 DASD READ                   0       N/C                                              
                                                 TAPE READ                   0       N/C                                              
0WRITE REQUESTS              48  0.000294      OFFLOAD REQUESTS              0       N/C      WRITE REQUESTS              0       N/C 
 CONT. CI / WRITE          1.00                BLOCKS / OFFLOAD           0.00                                                        
0OTHER WAITS                  0       N/C      OTHER WAITS                   0       N/C      CROSS-INVALIDATION ACTIVITY      TOTALS 
   ALLOCATE                   0       N/C        ALLOCATE                    0       N/C      -----------------------------  -------- 
   DEALLOCATE                 0       N/C        DEALLOCATE                  0       N/C                                              
   OPEN                       0       N/C        OPEN                        0       N/C      SYNCHRONOUS READS                     0 
   CLOSE                      0       N/C        CLOSE                       0       N/C        REFRESHED FROM GROUP BPOOL          0 
                                                 HSM RECALL                  0       N/C        REFRESHED FROM DASD                 0 
                                                 CATALOG LOCATE              0       N/C                                              
                                                 MULTI-DATA SET TAPE         0       N/C      SEQUENTIAL PREFETCHES                 0 
                                                 TAPE VOL POSITIONING        0       N/C        REFRESHED FROM GROUP BPOOL          0 
                                                 WTOR ISSUED                 0       N/C        REFRESHED FROM DASD                 0 
                                                 DATA SET UNAVAILABLE        0       N/C                                              
                                                 PHYSICAL UNIT UNAV.         0       N/C                                              
                                                 RDR SERV.UNAVAILABLE        0       N/C