Example: DBCTL
Sample Report Forms are provided to help you format
a List report to show DBCTL transaction activity:
- IMSDBLST
- Transaction DBCTL Usage Analysis
- IMSRQLST
- Transaction DBCTL Req 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.
Figure 1. New Report Form -
Select Field Categories: DBCTL
Select Field Categories
Command ===> ____________________________________________________________
CMF Groups:
/ DFHAPPL - Application naming / DFHJOUR - Journal
/ DFHBTS - BTS / DFHMAPP - BMS Maps
/ DFHCHNL - CHANNEL option / DFHPROG - Program Control
/ DFHCICS - CICS task information / DFHRMI - Resource Manager (RMI)
/ DFHDATA - Data processing / DFHSOCK - Secure Sockets
/ DFHDEST - Transient Data / DFHSTOR - Storage Control
/ DFHDOCH - Document Handler / DFHSYNC - Syncpoint processing
/ DFHEJBS - EJB Server / DFHTASK - Task Control
/ DFHFEPI - Front End (FEPI) / DFHTEMP - Temporary Storage
/ DFHFILE - File Control / DFHTERM - Terminal Control
/ DFHWEBB - Web Interface
Region Types:
_ AOR - Application-owning User Fields:
_ FOR - File-owning / DBCTL - IMS DBCTL
_ TOR - Terminal-owning _ CROSSYS - Cross-System
_ DB2 - AOR with DB2 _ OMCICS - OMEGAMON
Move the fields of interest above EOR to include them in the report.
Figure 2. LIST Report Form: DBCTL fields
EDIT LIST Report Form - DBCTLIST
Field - User Field -
Name Type Length Dictionary Definition Offset Length
__ TRAN____ _______ 4 TRAN DFHTASK C001 ___ ___
__ PSBNAME_ _______ 8 PSBNAME DBCTL C001 ___ ___
__ START___ TIMET__ 12 START DFHCICS T005 ___ ___
__ RESPONSE _______ 8 RESP CICSPA D901 ___ ___
__ CPU_____ TIME___ 8 USRCPUT DFHTASK S008 ___ ___
__ DISPATCH TIME___ 8 USRDISPT DFHTASK S007 ___ ___
__ SUSPEND_ TIME___ 8 SUSPTIME DFHTASK S014 ___ ___
__ POOLWAIT _______ 8 POOLWAIT DBCTL A002 ___ ___
__ INTCWAIT _______ 8 INTCWAIT DBCTL A003 ___ ___
__ SCHTELAP _______ 8 SCHTELAP DBCTL A004 ___ ___
__ DBIOELAP _______ 8 DBIOELAP DBCTL A005 ___ ___
__ PILOCKEL _______ 8 PILOCKEL DBCTL A006 ___ ___
__ DBIOCALL _______ 8 DBIOCALL DBCTL A007 ___ ___
__ DLICALLS _______ 8 DLICALLS DBCTL A017 ___ ___
__ EOR_____ _______ ___ ___
__ EOX_____ _______ ___ ___
This will produce a report with the following format.
Figure 3. Performance
List report: DBCTL transactions
V5R3M0 CICS Performance Analyzer
Performance List
LIST0001 Printed at 12:34:56 02/15/2015 Data from 15:58:48 2/19/2010 APPLID CICPAOR1 Page 1
DBCTL transactions
Tran PSB Start Response User CPU Dispatch Suspend PoolWait ICwait SchedElp DBIOElap PILockEl DBIOcall DLIcalls
Time Time Time Time Time Time Time Time Time Time
DLI0 DDLPSB51 15:58:47.251 1.0479 .0483 .9427 .1052 .0000 .0000 .0079 .0000 .0000 0 0
DLI0 DDLPSB51 15:58:49.634 .0615 .0118 .0168 .0447 .0000 .0000 .0034 .0000 .0000 0 0
DLI0 DDLPSB51 16:51:16.979 1.4467 .0474 1.2820 .1648 .0000 .0000 .0080 .0000 .0000 0 0
DLI0 DDLPSB51 16:58:03.662 .0934 .0114 .0176 .0758 .0000 .0000 .0034 .0000 .0000 0 0
DLI0 DDLPSB51 16:58:04.244 .0933 .0114 .0161 .0772 .0000 .0000 .0035 .0000 .0000 0 0
DLI2 DDLPSB51 17:00:16.874 3.0710 .0110 .1065 2.9644 .0000 .0000 .0034 .0000 .0000 0 0
DLI7 DDLPSB51 17:00:17.180 3.0274 .0116 .1441 2.8833 .0000 .0000 .0245 .0000 .0000 0 0
DLI3 DDLPSB51 17:00:17.212 3.2297 .0129 .0108 3.2189 .0000 .0000 .0056 .0000 .0000 0 0
DLI4 DDLPSB51 17:00:17.213 3.7488 .0109 .0112 3.7375 .0000 .0000 .0036 .0000 .0000 0 0
DLI9 DDLPSB51 17:00:17.217 18.7260 .0108 2.8553 15.8707 .0000 .0000 .0034 .0000 .0000 0 0
DLI1 DDLPSB51 17:00:17.218 18.8168 .0131 .0227 18.7941 .0000 .0000 .0041 .0000 .0000 0 0
DLI0 DDLPSB51 17:00:17.217 18.9042 .0130 2.7601 16.1441 .0000 .0000 .0034 .0000 .0000 0 0
. . .
DLI0 DDLPSB51 13:14:14.187 .5046 .0439 .1369 .3676 .0000 .0000 .0035 .0000 .0000 0 0
DLI0 PSB99 13:01:22.918 5.9288 2.1340 3.8341 2.0947 .0000 .0000 1.0004 .0000 .0000 0 2
DLI0 PSB99 13:17:35.232 3.5302 2.1659 2.7387 .7914 .0000 .0000 .0010 .0000 .0000 0 2
DLI0 PSB99 13:45:38.833 3.4382 2.1744 2.4742 .9640 .0000 .0000 .0010 .0000 .0000 0 2
DLI0 PSB99 13:48:16.354 1.0711 .0428 .2282 .8429 .0000 .0000 .0024 .0000 .0000 0 1
DLI0 PSB99 13:48:24.131 .2516 .0118 .0184 .2332 .0000 .0000 .0010 .0000 .0000 0 1
DLI0 PSB99 13:48:25.012 .3658 .0117 .0168 .3490 .0000 .0000 .0011 .0000 .0000 0 1
DLI0 PSB99 13:48:25.963 .3745 .0118 .0174 .3571 .0000 .0000 .0010 .0000 .0000 0 1
DLI0 PSB99 13:48:26.919 .2871 .0116 .0180 .2691 .0000 .0000 .0010 .0000 .0000 0 1
DLI0 PSB99 13:48:27.907 .2511 .0117 .0170 .2341 .0000 .0000 .0010 .0000 .0000 0 1
DLI0 PSB99 15:36:20.458 .7925 .0451 .2664 .5261 .0000 .0000 .0010 .0000 .0000 0 1
DLI0 PSB99 15:38:29.047 .6985 .0466 .1953 .5032 .0000 .0000 .0011 .0000 .0000 0 2
DLI0 PSB99 15:38:50.508 .5742 .0457 .1260 .4482 .0000 .0000 .0010 .0000 .0000 0 2
DLI0 PSB99 15:49:07.072 .9596 .0486 .1879 .7717 .0000 .0000 .0010 .0000 .0000 0 2
DLI2 PSB99 15:53:29.716 91.8213 1.8717 2.0128 89.8085 .0000 .0000 .0010 .0000 .0000 0 1
DLI3 PSB99 15:53:30.402 156.501 1.9866 24.4980 132.003 .0000 .0000 .0055 .0000 .0000 0 1
DLI5 PSB99 15:53:30.497 233.355 1.9771 18.1590 215.196 .0000 .0000 .0049 .0000 .0000 0 1
DLI1 PSB99 15:56:53.478 95.2870 1.9511 16.4508 78.8363 .0000 .0000 .0050 .0000 .0000 0 1
Note: IMS™ Performance Analyzer
(IMS PA) can provide a more comprehensive
analysis of IMS DBCTL performance.