An example of a Performance Summary report showing a summary of DBCTL activity by transaction is shown in Figure 2. The report is sorted by transaction ID and PSB name.
You can edit the sample forms to tailor your reports. Alternatively, you can create a new Report Form, select to specify Field Categories, and select DBCTL to populate the form with DBCTL fields as shown in Figure 1.
Move the fields of interest above EOR to include them in the report.
EDIT SUMMARY Report Form - DBCTLSUM Field Sort - User Field - Name + K O Type Fn Length Dictionary Definition Offset Length __ TRAN____ K A _______ ___ 8 TRAN DFHTASK C001 ___ ___ __ PSBNAME_ K A _______ ___ 8 PSBNAME DBCTL C001 ___ ___ __ TASKCNT_ _______ ___ 8 TASKCNT CICSPA X902 ___ ___ __ RESPONSE _______ AVE 8 RESP CICSPA D901 ___ ___ __ CPU_____ TIME___ AVE 8 USRCPUT DFHTASK S008 ___ ___ __ DISPATCH TIME___ AVE 8 USRDISPT DFHTASK S007 ___ ___ __ SUSPEND_ TIME___ AVE 8 SUSPTIME DFHTASK S014 ___ ___ __ POOLWAIT _______ AVE 8 POOLWAIT DBCTL A002 ___ ___ __ INTCWAIT _______ AVE 8 INTCWAIT DBCTL A003 ___ ___ __ SCHTELAP _______ AVE 8 SCHTELAP DBCTL A004 ___ ___ __ DBIOELAP _______ AVE 8 DBIOELAP DBCTL A005 ___ ___ __ PILOCKEL _______ AVE 8 PILOCKEL DBCTL A006 ___ ___ __ DBIOCALL _______ AVE 8 DBIOCALL DBCTL A007 ___ ___ __ DLICALLS _______ AVE 8 DLICALLS DBCTL A017 ___ ___ __ EOR_____ _______ ___ ___ ___ __ EOX_____ _______ ___ ___ ___ __ APPLID__ K * _______ ___ 8 APPLID CICSPA C903 ___ ___ __ START___ K * TIMES__ ___ 8 START DFHCICS T005 ___ ___
V3R2M0 CICS Performance Analyzer
Performance Summary
SUMM0001 Printed at 12:03:45 3/15/2011 Data from 15:58:47 2/19/2010 to 15:58:28 2/21/2010 Page 1
*** All DBCTL transactions ***
Avg Avg Avg Avg Avg Avg Avg Avg Avg Avg Avg
Tran PSB #Tasks Response User CPU Dispatch Suspend PoolWait ICwait SchedElp DBIOElap PILockEl DBIOcall DLIcalls
Time Time Time Time Time Time Time Time Time Count Count
DLI0 DDLPSB51 16 9.3221 .0255 .5016 8.8205 .0000 .0000 .0104 .0000 .0000 0 0
DLI0 PSB99 13 1.4249 .5201 .7799 .6450 .0000 .0000 .0780 .0000 .0000 0 1
DLI0 29 5.7820 .2472 .6264 5.1556 .0000 .0000 .0407 .0000 .0000 0 1
DLI1 DDLPSB51 4 26.4267 .0125 .8290 25.5977 .0000 .0000 .0041 .0000 .0000 0 0
DLI1 PSB99 1 95.2870 1.9511 16.4508 78.8363 .0000 .0000 .0050 .0000 .0000 0 1
DLI1 5 40.1988 .4003 3.9534 36.2454 .0000 .0000 .0043 .0000 .0000 0 0
DLI2 DDLPSB51 4 19.3463 .0125 .2029 19.1433 .0000 .0000 .0040 .0000 .0000 0 0
DLI2 PSB99 1 91.8213 1.8717 2.0128 89.8085 .0000 .0000 .0010 .0000 .0000 0 1
DLI2 5 33.8413 .3843 .5649 33.2764 .0000 .0000 .0034 .0000 .0000 0 0