Example

The following DB2® Long Summary report provides an example of Class 3 Suspend time.

Figure 1. DB2 Long Summary report showing Class 3 Suspend time
V3R2M0                                                 CICS Performance Analyzer
                                                           DB2 - Long Summary
 
DB2R0001 Printed at 12:03:45  3/15/2011    Data from 22:27:36  3/10/2010 to 22:27:36  3/10/2010    APPLID HMASW1A1     Page       1 
                                                                                                                                    
                                                                                                                                    
                              Avg      Max       Avg      Max       Avg      Max       Avg      Max       Avg      Max              
Tran/ Program/ #Tasks/   DB2ConWt DB2ConWt  DB2ThdWt DB2ThdWt   DB2Rqst  DB2Rqst   UserCPU  UserCPU  Response Response   #Abends    
SSID  Planname #Threads      Time     Time      Time     Time     Count    Count      Time     Time      Time     Time              
                                                                                                                                    
W001  MSHC301         1     .0000    .0000     .0000    .0000       4.0        4   .018432  .018432     .6679    .6679         0    
                                                                                                                                    
DBH1  PWH0001         1  Thread Utilization       Entry=       1  Pool=       0  Command=       0                                   
                         Class1: Thread Time      Avg: Elapsed=   .5509  CPU= .002450                                               
                                                  Max: Elapsed=   .5509  CPU= .002450                                               
                         Class2: In-DB2 Time      Avg: Elapsed=   .0145  CPU= .001930                                               
                                                  Max: Elapsed=   .0145  CPU= .001930                                               
                         Class3: Suspend Time     Avg: Total  = .003368  I/O= .003368  Lock/Latch= .000000  Other= .000000          
                                                  Max: Total  = .003368  I/O= .003368  Lock/Latch= .000000  Other= .000000          
                         Buffer Manager Summary   Avg: GtPgRq=    10.0  SyPgUp=     3.0                                             
                                                  Max: GtPgRq=      10  SyPgUp=       3