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.
CICSPA DB2(LONG(ALL))
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
The DB2 Long Summary report provides the following information: