DB2 examples

Example 1: Default report (DB2® Short Summary)

This example produces the default report like that shown in Figure 1. The default is the Short Summary report with both CMF performance records (SMF 110) and DB2 accounting (SMF 101) records reported. CMF performance records with DB2REQCT=0 are not included.
CICSPA DB2
The following command achieves the same:
CICSPA DB2(SHORTSUM)
Figure 1. DB2 report (Short Summary)
V5R3M0                                                  CICS Performance Analyzer
                                                           DB2 - Short Summary
 
DB2R0001 Printed at 12:34:56 02/15/2015    Data from 15:48:40  7/12/2004 to 15:50:42  7/12/2004    APPLID CICS53T1     Page       1 
                                                                                                                                    
Tran/ Program/ #Tasks/  ............Average Elapsed Time............  .....Average CPU Time.....  .....Average Count....... #Abends 
SSID  Planname #Threads Response  Thread   In-DB2  DB2ConWt DB2ThdWt    User    Thread   In-DB2   DB2Reqs  GetPage SysPgUpd         
                                                                                                                                    
CRD7  CORD07P         2    .4043                      .0000    .0000   .031008                        3.0                          0
DB2P  CPAPLAN         2             .0631    .0106                              .011408  .009811               4.0       .0         
                                                                                                                                    
CRD9  CORD09P         2    .4091                      .0000    .0000   .030680                        3.0                          0
DB2P  CPAPLAN         2             .0776    .0104                              .011478  .009870               4.0       .0         
                                                                                                                                    
SALE  DFH0SAL2       10    .2271                      .0000    .0000   .038147                        1.0                          0
DB2P  CPAPLAN        10             .1394    .0033                              .003865  .003136               N/P      N/P         
                                                                                                                                    
SAL1  DFH0SAL1        2   1.0268                      .0000    .0000   .038656                        1.0                          0
DB2P  CPAPLAN         2             .7898    .0033                              .003843  .003114               N/P      N/P         
                                                                                                                                    
*** Total ***        16    .3720                      .0000    .0000   .036385                        1.5                          0
DB2P                 16             .2034    .0051                              .005757  .004809               4.0       .0         

Example 2: DB2 Long Summary

This example produces a DB2 Long Summary like that in Figure 2.
CICSPA DB2(LONG(CLASS1,CLASS2,BUFFER,LOCKING))
These are the default DB2 accounting details for the DB2 Long Summary. The following command achieves the same:
CICSPA DB2(LONGSUM)
Figure 2. DB2 report (Long Summary)
V5R3M0                                                  CICS Performance Analyzer
                                                           DB2 - Long Summary
 
DB2R0001 Printed at 12:34:56 02/15/2015    Data from 16:58:04  7/03/2004 to 16:17:57  7/12/2004    APPLID CICS53A1     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                                              
                         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          
                                                                                                                                   
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                                     
                         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 
 . . .
 
*** 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                                           
                         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       

Example 3: DB2 List and DB2 Recap

This produces a DB2 List report like that in Figure 3. An example of the Recap report which is always printed at the end of processing is shown in Figure 4.
CICSPA DB2(LIST(ALL),LISTZERO)
Figure 3. DB2 report (List)
V5R3M0                                                  CICS Performance Analyzer
                                                                DB2 - List
 
DB2R0001 Printed at 12:34:56 02/15/2015    Data from 15:41:19  7/12/2004 to 16:19:15  7/12/2004                        Page       1
 
Tran/ Userid/ Program/                 UOW R               ..DB2 Wait Time..   DB2    User CPU                            Response A
SSID  Authid  Planname  APPLID    Task Seq T Term  LUName   Connect  Thread   ReqCnt    Time     Start Time    Stop Time    Time   B
 
CRD8 CICSUSER CORD08P  CICPAOR1     53   2 T <AAK CICPTOR1    .0000    .0000       22    .0185  15:49:40.023 15:49:40.105    .0827
CRD5 CICSUSER CORD05P  CICPAOR1     52   2 T <AAK CICPTOR1    .0000    .0000       12    .0137  15:49:39.960 15:49:40.016    .0566
CRDD CICSUSER CORD13P  CICPTOR1     45   1 T 0013 TCP00013      N/A      N/A        0    .0390  15:49:39.521 15:49:40.121    .6006
 
DB2P CICSUSER CPAPLAN  CICPAOR1     52  Thread Identification   ID=POOLCRD50001  NETName=P390.TCP00013      UOWID=1F7D3A6472BA
                                                                Begin Time: 15:49:39.969  7/12/03  End Time: 15:49:40.007  7/12/03
                                        Class1: Thread Time     Elapsed=   .0379  CPU= .019536
                                        Class2: In-DB2 Time     Elapsed=   .0184  CPU= .014040
                                        Class3: Suspend Time    Total  =     N/P  I/O=     N/P  Lock/Latch=     N/P  Other=     N/P
                                        Buffer Manager Summary  GtPgRq=       2  SyPgUp=       0
                                        Locking Summary         Suspnd=       0  DeadLk=       0  TmeOut=       0  MxPgLk=       1
                                        SQL DML Query/Update    Sel=       0  Ins=       0  Upd=       0  Del=       0
                                        SQL DML 'Other'         Des=       0  Pre=       0  Ope=       1  Fet=      10  Clo=       1
 
DB2P CICSUSER CPAPLAN  CICPAOR1     53  Thread Identification   ID=POOLCRD50001  NETName=P390.TCP00013      UOWID=1F7D3A6472BA
                                                                Begin Time: 15:49:40.032  7/12/03  End Time: 15:49:40.097  7/12/03
                                        Class1: Thread Time     Elapsed=   .0654  CPU= .031185
                                        Class2: In-DB2 Time     Elapsed=   .0231  CPU= .021452
                                        Class3: Suspend Time    Total  =     N/P  I/O=     N/P  Lock/Latch=     N/P  Other=     N/P
                                        Buffer Manager Summary  GtPgRq=       2  SyPgUp=       0
                                        Locking Summary         Suspnd=       0  DeadLk=       0  TmeOut=       0  MxPgLk=       1
                                        SQL DML Query/Update    Sel=       0  Ins=       0  Upd=       0  Del=       0
                                        SQL DML 'Other'         Des=       0  Pre=       0  Ope=       1  Fet=      20  Clo=       1
   . . .
Figure 4. DB2 report (Recap)
V5R3M0                                                  CICS Performance Analyzer
                                                               DB2 - Recap
 
DB2R0001 Printed at 12:34:56 02/15/2015    Data from 15:41:19  7/12/2004 to 16:19:15  7/12/2004                        Page       1
 
Records processed by the DB2 report processor:
                                                           Count     % of Total
  CMF performance class records:                         ---------   ----------
    Included  . . . . . . . . . . . . . . . . . . . .          120        .6%
    Excluded:
      CICS PA record selection  . . . . . . . . . . .       20,670      99.4%
      No DB2 activity . . . . . . . . . . . . . . . .            0        .0%
      Other . . . . . . . . . . . . . . . . . . . . .            0        .0%
    Total . . . . . . . . . . . . . . . . . . . . . .       20,790
 
  DB2 accounting records:
    Included  . . . . . . . . . . . . . . . . . . . .           30        .5%
    Excluded:
      CICS PA record selection  . . . . . . . . . . .            0        .0%
      Not CICS Attach . . . . . . . . . . . . . . . .          368       6.6%
      Accounting Token not set  . . . . . . . . . . .        5,196      92.9%
      Other . . . . . . . . . . . . . . . . . . . . .            0        .0%
    Total . . . . . . . . . . . . . . . . . . . . . .        5,594
 
 
Network units-of-work with DB2 activity:
                                                           Count     % of Total
  Network units-of-work where:                           ---------   ----------
    DB2 accounting records were resolved  . . . . . .           30     100.0%
    DB2 accounting records were not resolved  . . . .            0        .0%
    DB2 accounting records were not present . . . . .            0        .0%
    Total . . . . . . . . . . . . . . . . . . . . . .           30
 
  CMF performance class records with DB2 activity:
    Matched to a DB2 accounting record  . . . . . . .           30     100.0%
    Not matched to any DB2 accounting records . . . .            0        .0%
    Total . . . . . . . . . . . . . . . . . . . . . .           30
 
  CMF performance class records with no DB2 activity:
    Total . . . . . . . . . . . . . . . . . . . . . .            0
 
  DB2 accounting records:
    Eligible for summary reporting  . . . . . . . . .           30     100.0%
    Matched to a single CICS task   . . . . . . . . .           30     100.0%
    Matched to two or more CICS tasks . . . . . . . .            0        .0%
    Not matched to any CICS tasks . . . . . . . . . .            0        .0%
    Total . . . . . . . . . . . . . . . . . . . . . .           30