Example: Top 20 worst transactions by various criteria
Sample Report Forms are provided to help you format
the report for different purposes:
- BADCHMDS
- Top 20 worst change-TCB mode requests
- BADCPU
- Top 20 worst CPU times
- BADDB2RQ
- Top 20 worst DB2 requests
- BADFCRQ
- Top 20 worst file requests
- BADRESP
- Top 20 worst response times
- BADRMI
- Top 20 worst CICS RMI times
- BADRMIRQ
- Top 20 worst CICS RMI requests
- BADSUSP
- Top 20 worst suspend times
BADTSAWT
Top 20 Worst Auxiliary TS Waits
- BADTDRQ
- Top 20 worst transient data queue requests
- BADTSRQ
- Top 20 worst temporary storage queue requests
BADTSSWT
Top 20 Worst Shared TS Waits
- BADWBRQ
- Top 20 worst CICS Web requests
- BADWMQRQ
- Top 20 worst WebSphere MQ requests
You can edit and change a form to reformat the report. The example in Figure 2 was based on the sample form BADRESP, then modified and saved as BADTRANS.
Figure 1. LISTX Report Form: using Sort Sequence and Limit
EDIT LISTX Report Form - BADTRANS
Field
Name S Type Limit Description
__ TRAN____ A _______ ________ Transaction identifier
__ RESPONSE D _______ 10______ Transaction response time
__ TERM____ * _______ ________ Terminal ID
__ STYPE___ _ _______ ________ Transaction start type
__ USERID__ * _______ ________ User ID
__ RSYSID__ _ _______ ________ Remote System ID
__ PROGRAM_ _ _______ ________ Program name
__ TASKNO__ _ _______ ________ Transaction identification number
__ STOP____ * TIMES__ ________ Task stop time
__ RESPONSE * _______ ________ Transaction response time
__ DISPATCH * TIME___ ________ Dispatch time
__ CPU_____ * TIME___ ________ CPU time
__ SUSPEND_ * TIME___ ________ Suspend time
__ DISPWAIT * TIME___ ________ Redispatch wait time
__ FCWAIT__ _ TIME___ ________ File I/O wait time
__ IRWAIT__ _ TIME___ ________ MRO link wait time
__ EOR_____ _ _______ ---------------- End of Report --------------
__ EOX_____ _ _______ ---------------- End of Extract -------------
__ FCAMCT__ * _______ ________ File access-method requests
To format this report, specify that the records are sorted by descending response time within ascending transaction ID. Limit the performance class records processed to the first 10 records (the longest 10 response times) for each transaction ID.
Figure 2. Performance
List Extended report: top 10 response times by transaction
V5R3M0 CICS Performance Analyzer
Performance List Extended
LSTX0001 Printed at 12:34:56 02/15/2015 Data from 11:10:51 2/14/2010 to 11:34:13 2/14/2010 Page 1
Response Times by Transaction ID *** 10 worst times ***
Tran Response Term SC Userid RSID Program TaskNo Stop Dispatch User CPU Suspend DispWait FC Wait IR Wait
Time Time Time Time Time Time Time Time
AADD .0945 S23C TO BRENNER DFHSAALL 52 11:12:54 .0831 .0084 .0114 .0113 .0000 .0000
AADD .0636 S23C TO BRENNER DFHSAALL 54 11:13:06 .0619 .0047 .0017 .0016 .0000 .0000
AADD .0029 S23C TP BRENNER DFHSAALL 65 11:14:27 .0026 .0017 .0003 .0002 .0000 .0000
AADD .0026 S23C TP BRENNER DFHSAALL 561 11:27:02 .0022 .0017 .0003 .0002 .0000 .0000
AADD .0023 TC26 TP GBURGES DFHSAALL 138 11:20:15 .0022 .0013 .0001 .0000 .0000 .0000
AADD .0023 TC26 TP GBURGES DFHSAALL 184 11:21:58 .0022 .0013 .0001 .0000 .0000 .0000
AADD .0022 TC26 TO GBURGES DFHSAALL 183 11:21:51 .0022 .0012 .0001 .0000 .0000 .0000
AADD .0022 TC26 TO GBURGES DFHSAALL 137 11:20:08 .0021 .0012 .0001 .0000 .0000 .0000
AADD .0016 S23C TO BRENNER DFHSAALL 551 11:26:41 .0016 .0013 .0001 .0000 .0000 .0000
AADD .0011 TC26 TO GBURGES DFHSAALL 136 11:20:04 .0010 .0010 .0001 .0000 .0000 .0000
ABRW .6982 P015 TO CBAKER DFHSABRW 139 11:16:51 .6717 .0385 .0264 .0111 .0051 .0000
ABRW .5819 S23D TO BRENNER DFHSABRW 53 11:12:19 .0783 .0121 .5037 .0127 .0000 .4908
ABRW .0156 TC26 TP GBURGES DFHSABRW 128 11:19:57 .0028 .0024 .0128 .0000 .0000 .0127
ABRW .0146 TC26 TO GBURGES DFHSABRW 164 11:21:05 .0030 .0023 .0115 .0000 .0000 .0114
ABRW .0124 TC26 TP GBURGES DFHSABRW 169 11:21:17 .0043 .0028 .0080 .0000 .0000 .0080
ABRW .0120 TC32 TP GBURGES DFHSABRW 391 11:24:38 .0120 .0017 .0001 .0000 .0000 .0000
ABRW .0097 TC26 TP GBURGES DFHSABRW 175 11:21:27 .0059 .0025 .0038 .0000 .0000 .0037
ABRW .0094 TC26 TP GBURGES DFHSABRW 117 11:19:52 .0036 .0024 .0058 .0000 .0000 .0057
ABRW .0085 TC26 TP GBURGES DFHSABRW 170 11:21:19 .0037 .0024 .0048 .0000 .0000 .0048
ABRW .0085 TC26 TP GBURGES DFHSABRW 176 11:21:29 .0043 .0024 .0042 .0001 .0000 .0042
AINQ .0040 TC26 TO GBURGES DFHSAALL 187 11:22:14 .0027 .0017 .0013 .0000 .0000 .0013
AINQ .0024 S23C TO BRENNER DFHSAALL 574 11:27:26 .0016 .0015 .0008 .0000 .0000 .0000
AINQ .0023 S23C TO BRENNER DFHSAALL 564 11:27:11 .0022 .0015 .0001 .0000 .0000 .0000
AINQ .0020 S23C TO BRENNER DFHSAALL 341 11:21:19 .0019 .0014 .0001 .0000 .0000 .0000
AINQ .0020 S23C TO BRENNER DFHSAALL 328 11:21:09 .0019 .0012 .0001 .0000 .0000 .0000
AINQ .0018 S23C TO BRENNER DFHSAALL 580 11:27:34 .0017 .0014 .0001 .0000 .0000 .0000
AINQ .0018 S23C TO BRENNER DFHSAALL 112 11:14:46 .0017 .0016 .0001 .0000 .0000 .0000
AINQ .0014 R11 TO CBAKER DFHSAALL 232 11:26:30 .0013 .0012 .0000 .0000 .0000 .0000
AINQ .0013 S23C TO BRENNER DFHSAALL 569 11:27:19 .0013 .0013 .0001 .0000 .0000 .0000
AINQ .0012 TC26 TO GBURGES DFHSAALL 186 11:22:08 .0011 .0010 .0001 .0000 .0000 .0000
AMNU .1724 S23D TO BRENNER DFHSAMNU 50 11:11:53 .1720 .0091 .0004 .0004 .0000 .0000
AMNU .0713 CAAD TO CBAKER DFHSAMNU 249 11:19:41 .0519 .0085 .0194 .0042 .0000 .0000