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
BADTDRQ
Top 20 worst transient data queue requests
BADTSRQ
Top 20 worst temporary storage queue requests
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
 V5R1M0                                          CICS Performance Analyzer
                                                 Performance List Extended
 
LSTX0001 Printed at 12:03:45 04/17/2013     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

Information Information

Feedback


Timestamp icon Last updated: Saturday, 8 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///report-reference/cparr59.htm