Long Summary report

The DB2® Long Summary report provides a summary of DB2 activity by transaction and program within APPLID, giving average and maximum values for each.

The Summary report represents a subset of the total data presented in the DB2 List report. It includes DB2 data that can be matched within a network unit-of-work to a single task, or multiple tasks that all used the same transaction and program. There is no data apportioning by CICS PA.

The DB2 report shown in Figure 1 was created using the command:
CICSPA DB2(LONG(ALL))
Figure 1. DB2 Long Summary report
V5R1M0                                                  CICS Performance Analyzer
                                                           DB2 - Long Summary
 
DB2R0001 Printed at 12:03:45 04/17/2013    Data from 15:41:19  7/12/2010 to 16:19:15  7/12/2010    APPLID CICPAOR1     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             
                                                                                                                                   
CRDE  CORD14P         2     .0000    .0000     .0000    .0000      24.0       24   .036896  .052480     .3141    .5208         0   
                                                                                                                                   
DB2P  CPAPLAN         4  Thread Utilization       Entry=       0  Pool=       4  Command=       0                                  
                         Class1: Thread Time      Avg: Elapsed=   .0369  CPU= .020809                                              
                                                  Max: Elapsed=   .0395  CPU= .024879                                              
                         Class2: In-DB2 Time      Avg: Elapsed=   .0166  CPU= .015381                                              
                                                  Max: Elapsed=   .0201  CPU= .019369                                              
                         Class3: Suspend Time     Avg: Total  =     N/P  I/O=     N/P  Lock/Latch=     N/P  Other=     N/P         
                                                  Max: Total  =     N/P  I/O=     N/P  Lock/Latch=     N/P  Other=     N/P         
                         Buffer Manager Summary   Avg: GtPgRq=     3.3  SyPgUp=      .0                                            
                                                  Max: GtPgRq=       7  SyPgUp=       0                                            
                         Locking Summary          Avg: Suspnd=      .0  DeadLk=      .0  TmeOut=      .0  MxPgLk=     1.0          
                                                  Max: Suspnd=       0  DeadLk=       0  TmeOut=       0  MxPgLk=       1          
                         SQL DML Query/Update     Avg: Sel=      .0  Ins=      .0  Upd=      .0  Del=      .0                      
                                                  Max: Sel=       0  Ins=       0  Upd=       0  Del=       0                      
                         SQL DML 'Other'          Avg: Des=      .0  Pre=      .0  Ope=     1.0  Fet=    10.0  Clo=     1.0     
                                                  Max: Des=       0  Pre=       0  Ope=       1  Fet=      10  Clo=       1     
                                                                                                                                
CRD4  CORD04P         3     .0000    .0000     .0000    .0000    3075.3     9178  1.593973 4.693520    8.5758  24.9328         0
                                                                                                                                
DB2P  CPAPLAN         4  Thread Utilization       Entry=       0  Pool=       4  Command=       0                               
                         Class1: Thread Time      Avg: Elapsed=   .0569  CPU= .025045                                           
                                                  Max: Elapsed=   .0850  CPU= .029168                                           
                         Class2: In-DB2 Time      Avg: Elapsed=   .0205  CPU= .018777                                           
                                                  Max: Elapsed=   .0241  CPU= .022986                                           
                         Class3: Suspend Time     Avg: Total  =     N/P  I/O=     N/P  Lock/Latch=     N/P  Other=     N/P      
                                                  Max: Total  =     N/P  I/O=     N/P  Lock/Latch=     N/P  Other=     N/P      
                         Buffer Manager Summary   Avg: GtPgRq=     3.3  SyPgUp=      .0                                         
                                                  Max: GtPgRq=       7  SyPgUp=       0                                         
                         Locking Summary          Avg: Suspnd=      .0  DeadLk=      .0  TmeOut=      .0  MxPgLk=     1.0       
                                                  Max: Suspnd=       0  DeadLk=       0  TmeOut=       0  MxPgLk=       1       
                         SQL DML Query/Update     Avg: Sel=      .0  Ins=      .0  Upd=      .0  Del=      .0                   
                                                  Max: Sel=       0  Ins=       0  Upd=       0  Del=       0                   
                         SQL DML 'Other'          Avg: Des=      .0  Pre=      .0  Ope=     1.0  Fet=    10.0  Clo=     1.0 
                                                  Max: Des=       0  Pre=       0  Ope=       1  Fet=      10  Clo=       1 
 . . .
 
*** Total ***        23     .0000    .0000     .0000    .0000     417.3     9178   .227745 4.693520    1.2403  24.9328         0
                                                                                                                                
DB2P                 26  Thread Utilization       Entry=       0  Pool=      26  Command=       0                               
                         Class1: Thread Time      Avg: Elapsed=   .0702  CPU= .025824                                           
                                                  Max: Elapsed=   .5211  CPU= .055524                                           
                         Class2: In-DB2 Time      Avg: Elapsed=   .0204  CPU= .018508                                           
                                                  Max: Elapsed=   .0471  CPU= .040673                                           
                         Class3: Suspend Time     Avg: Total  =     N/P  I/O=     N/P  Lock/Latch=     N/P  Other=     N/P      
                                                  Max: Total  =     N/P  I/O=     N/P  Lock/Latch=     N/P  Other=     N/P      
                         Buffer Manager Summary   Avg: GtPgRq=     2.8  SyPgUp=      .0                                         
                                                  Max: GtPgRq=      11  SyPgUp=       0                                         
                         Locking Summary          Avg: Suspnd=      .0  DeadLk=      .0  TmeOut=      .0  MxPgLk=     1.0       
                                                  Max: Suspnd=       0  DeadLk=       0  TmeOut=       0  MxPgLk=       1       
                         SQL DML Query/Update     Avg: Sel=      .0  Ins=      .0  Upd=      .0  Del=      .0                   
                                                  Max: Sel=       0  Ins=       0  Upd=       0  Del=       0                   
                         SQL DML 'Other'          Avg: Des=      .0  Pre=      .0  Ope=     1.2  Fet=    13.8  Clo=     1.2     
                                                  Max: Des=       0  Pre=       0  Ope=       2  Fet=      30  Clo=       2     
In the DB2 Long Summary report, two types of data are presented for each APPLID:
  1. The first is a single data line (in column format) for the CMF performance class data summarized by transaction and program
  2. The second is a block of data lines (in row format) for the associated DB2 accounting data summarized by SSID and planname

The DB2 Long Summary report provides the following information:


Information Information

Feedback


Timestamp icon Last updated: Thursday, 7 November 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//report-reference/db2lsumm.htm