From a Unix command prompt run report for 600 seconds (10 mins)
Code:
db2 call monreport.dbsummary \(600\)
I really like this report but and having issues believing some of the numbers for the given time period mostly the wait on I/O part. Now I know I have a few too many sort overflows but is this report saying that 20% of the CPU spent was waiting on I/O and 94% of that was waiting on the logs to read/write?

example:
Code:
  -- Detailed breakdown of TOTAL_WAIT_TIME --                                     
                                                                                  
                                %    Total                                        
                                ---  ---------------------------------------------
  TOTAL_WAIT_TIME               100  1280852                                      
                                                                                  
  I/O wait time                                                                   
    POOL_READ_TIME              0    3541                                         
    POOL_WRITE_TIME             0    8514                                         
    DIRECT_READ_TIME            0    45                                           
    DIRECT_WRITE_TIME           0    1061                                         
    LOG_DISK_WAIT_TIME          94   1204324                                      
  LOCK_WAIT_TIME                0    148                                          
  AGENT_WAIT_TIME               0    0                                            
  Network and FCM                                                                 
    TCPIP_SEND_WAIT_TIME        2    35814                                        
    TCPIP_RECV_WAIT_TIME        2    27405                                        
    IPC_SEND_WAIT_TIME          0    0                                            
    IPC_RECV_WAIT_TIME          0    0                                            
    FCM_SEND_WAIT_TIME          0    0                                            
    FCM_RECV_WAIT_TIME          0    0                                            
  WLM_QUEUE_TIME_TOTAL          0    0                                            
                                                                                  
  Component times                                                                 
  --------------------------------------------------------------------------------
  -- Detailed breakdown of processing time --                                     
                                                                                  
                                      %                 Total                     
                                      ----------------  --------------------------
  Total processing                    100               4830203                   
                                                                                  
  Section execution                                                               
    TOTAL_SECTION_PROC_TIME           81                3952997                   
      TOTAL_SECTION_SORT_PROC_TIME    0                 30677                     
  Compile                                                                         
    TOTAL_COMPILE_PROC_TIME           0                 19014                     
    TOTAL_IMPLICIT_COMPILE_PROC_TIME  0                 0                         
  Transaction end processing                                                      
    TOTAL_COMMIT_PROC_TIME            0                 23383                     
    TOTAL_ROLLBACK_PROC_TIME          0                 42                        
  Utilities                                                                       
    TOTAL_RUNSTATS_PROC_TIME          0                 0                         
    TOTAL_REORGS_PROC_TIME            0                 0                         
    TOTAL_LOAD_PROC_TIME              0                 0                         
                                                                                  
                                                                
  Sort                                                                            
  --------------------------------------------------------------------------------
  TOTAL_SORTS                         = 8769                                      
  SORT_OVERFLOWS                      = 139                                       
  POST_THRESHOLD_SORTS                = 0                                         
  POST_SHRTHRESHOLD_SORTS             = 0                                         
                                                                                  
  Network                                                                         
  --------------------------------------------------------------------------------
  Communications with remote clients                                              
  TCPIP_SEND_VOLUME per send          = 486        (755672122/1554606)            
  TCPIP_RECV_VOLUME per receive       = 1700       (2663405006/1565808)           
                                                                                  
  Communications with local clients                                               
  IPC_SEND_VOLUME per send            = 151        (1210/8)                       
  IPC_RECV_VOLUME per receive         = 189        (1518/8)                       
                                                                                  
  Fast communications manager                                                     
  FCM_SEND_VOLUME per send            = 0          (0/0)                          
  FCM_RECV_VOLUME per receive         = 0          (0/0)                          
                                                                                  
  Other                                                                           
  --------------------------------------------------------------------------------
  Compilation                                                                     
    TOTAL_COMPILATIONS                = 4610                                      
    PKG_CACHE_INSERTS                 = 4604                                      
    PKG_CACHE_LOOKUPS                 = 1643881                                   
  Catalog cache                                                                   
    CAT_CACHE_INSERTS                 = 16                                        
    CAT_CACHE_LOOKUPS                 = 21269                                     
  Transaction processing                                                          
    TOTAL_APP_COMMITS                 = 292067                                    
    INT_COMMITS                       = 34                                        
    TOTAL_APP_ROLLBACKS               = 1438                                      
    INT_ROLLBACKS                     = 0                                         
  Log buffer                                                                      
    NUM_LOG_BUFFER_FULL               = 0                                         
  Activities aborted/rejected                                                     
    ACT_ABORTED_TOTAL                 = 664                                       
    ACT_REJECTED_TOTAL                = 0                                         
  Workload management controls                                                    
    WLM_QUEUE_ASSIGNMENTS_TOTAL       = 0                                         
    WLM_QUEUE_TIME_TOTAL              = 0                                         
                                                                                  
  DB2 utility operations                                                          
  --------------------------------------------------------------------------------
    TOTAL_RUNSTATS                    = 0                                         
    TOTAL_REORGS                      = 0                                         
    TOTAL_LOADS                       = 0                                         
                                                                                  
  ================================================================================
  Part 2 - Application performance drill down                                     
                                                                                  
  Application performance database-wide                                           
  --------------------------------------------------------------------------------
  TOTAL_CPU_TIME          TOTAL_       TOTAL_APP_     ROWS_READ +                 
  per request             WAIT_TIME %  COMMITS        ROWS_MODIFIED               
  ----------------------  -----------  -------------  ----------------------------
  272                     20           292067         504010876