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