Example 1: Default report (DB2® Short Summary)
CICSPA DB2
CICSPA DB2(SHORTSUM)
V3R2M0 CICS Performance Analyzer
DB2 - Short Summary
DB2R0001 Printed at 12:03:45 3/15/2011 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
CICSPA DB2(LONG(CLASS1,CLASS2,BUFFER,LOCKING))
CICSPA DB2(LONGSUM)
V3R2M0 CICS Performance Analyzer
DB2 - Long Summary
DB2R0001 Printed at 12:03:45 3/15/2011 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
CICSPA DB2(LIST(ALL),LISTZERO)
V3R2M0 CICS Performance Analyzer
DB2 - List
DB2R0001 Printed at 12:03:45 3/15/2011 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
. . .
V3R2M0 CICS Performance Analyzer
DB2 - Recap
DB2R0001 Printed at 12:03:45 3/15/2011 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