Short Summary report
The DB2® Short Summary report is an abridged version of the Long Summary Report. It provides a summary of DB2 activity by transaction and program within APPLID giving averages for each (no maximums).
The following command produces the default report like that shown
in Figure 1. The default report is a
Short Summary with both CMF performance records and DB2 Accounting records included. CMF performance
records with DB2REQCT=0 are not included.
CICSPA DB2
or
CICSPA DB2(SHORTSUM)
Figure 1. DB2 Short Summary report
V5R3M0 CICS Performance Analyzer
DB2 - Short Summary
DB2R0001 Printed at 12:34:56 02/15/2015 Data from 15:41:19 7/12/2010 to 16:19:15 7/12/2010 APPLID CICPAOR1 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
In the DB2 Short Summary
report, two lines of data are presented for each APPLID:
- The first line is for the CMF performance class data summarized by transaction and program
- The second line is for the associated DB2 accounting data summarized by SSID and planname
The DB2 Short Summary report contains the following information: