Example: DBCTL
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.
Sample Report Forms are provided to help you format
Summary reports to show DBCTL transaction activity:
- IMSDBSUM
- Transaction DBCTL Usage Analysis
- IMSRQSUM
- Transaction DBCTL Req Analysis
- IMSSUM
- IMS DBCTL PSB Usage Analysis
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.
Figure 1. SUMMARY Report Form (DBCTL fields)
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 ___ ___
This produces a report with the following format:
Figure 2. Performance Summary report:
DBCTL activity
V5R3M0 CICS Performance Analyzer
Performance Summary
SUMM0001 Printed at 12:34:56 02/15/2015 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
Note: IMS™ Performance Analyzer
(IMS PA) can provide a more comprehensive analysis of IMS DBCTL performance.