LISTX examples

A set of sample Report Forms is provided with CICS PA. See Table 1 for the sample LISTX Report Forms. You can use these sample Report Forms with your Performance List Extended and Cross-System Work Extended reports. They provide a detailed picture of the many aspects affecting CICS® system performance.

Example 1: Default report
CICSPA LISTX

This example generates the default Performance List Extended report.

Example 2: Worst response times (all transactions)

Figure 1 shows an example of using the BY, LIMIT, and FIELDS operands to generate a Performance List Extended report sorted in descending order by response time. The LIMIT statement will limit the number of performance records processed to the first 20 and the resulting report will contain the 20 performance class records with the longest response time.

CICSPA LISTX(
         BY(RESPONSE(DESCEND)),
         LIMIT(RESPONSE(20)),
         FIELDS(TRAN,            Transaction ID
                TERM,            Terminal ID
                STYPE,           Start type of transaction
                USERID,          User ID
                RSYSID,          Remote System ID
                PROGRAM,         Initial program name
                TASKNO,          Transaction number
                STOP(TIMES),     Stop time (hh:mm:ss)
                RESPONSE,        Response time
                DISPATCH,        Dispatch time
                CPU,             CPU time
                SUSPEND,         Suspend time
                DISPWAIT,        Dispatch wait time
                FCWAIT,          File Control I/O wait time
                IRWAIT))         Inter-Region (MRO) I/O wait time
Figure 1. Performance List Extended report (using BY, LIMIT, FIELDS)
 V5R1M0                                                CICS Performance Analyzer
                                                       Performance List Extended
 
LSTX0001 Printed at 12:03:45  10/15/2012   Data from 11:10:51  2/14/2005 to 11:34:13  2/14/2005              Page       1
 
 Tran Term SC Userid   RSID Program    TaskNo Stop     Response Dispatch User CPU  Suspend DispWait  FC Wait  IR Wait
                                              Time       Time     Time     Time      Time     Time     Time     Time
 CSNC      U  CBAKER        DFHCRNP        21 11:34:10  1386.70   1.4058    .0233  1385.29    .0208    .0000    .0000
 CSNE      U  CBAKER        DFHZNAC        30 11:34:11  1379.15    .0980    .0226  1379.05    .0034    .0000    .0000
 CSHQ      U  CBAKER        DFHSHSY        23 11:33:50  1362.60    .3326    .0344  1362.27    .0140    .0000    .0000
 CWXN      U  CBAKER        DFHWBXN       119 11:34:06  1102.23    .0129    .0064  1102.22    .0218    .0000    .0000
 CWXN      U  CBAKER        DFHWBXN       331 11:34:12  782.697    .0041    .0037  782.693    .0103    .0000    .0000
 CEMT P052 TO CBAKER        DFHEMTP        61 11:23:34  592.514    .1550    .1244  592.359    .0026    .0000    .0000
 CEMT S208 TO BRENNER       DFHEMTP        66 11:20:31  308.883    .0021    .0012  308.881    .0000    .0000    .0000
 CWXN      U  CBAKER        DFHWBXN       333 11:25:52  282.577    .0068    .0034  282.570    .0048    .0000    .0000
 CEMT TC32 TO GBURGES       DFHEMTP       597 11:32:06  187.648    .0999    .0741  187.548    .0003    .0000    .0000
 STAT P012 TO CBAKER        DFH0STAT      263 11:33:38  158.917    .2575    .2219  158.659    .0016    .0000    .0000
 CEMT P015 TO CBAKER        DFHEMTP        64 11:16:46  144.153    .0131    .0078  144.140    .0001    .0000    .0000
 CEMT P056 TO CBAKER        DFHEMTP        67 11:20:33  141.000    .0045    .0032  140.996    .0000    .0000    .0000
 CEMT P056 TO CBAKER        DFHEMTP        67 11:22:57  102.494    .0034    .0027  102.490    .0000    .0000    .0000
 CEMT P056 TO CBAKER        DFHEMTP        67 11:18:12  95.0977    .0042    .0035  95.0935    .0000    .0000    .0000
 CEMT P056 TO CBAKER        DFHEMTP        52 11:14:53  81.3172    .0043    .0031  81.3129    .0000    .0000    .0000
 STAT R11  TO CBAKER        DFH0STAT      349 11:22:38  66.7720    .5048    .4620  66.2672    .0007    .0000  65.7887
 CEMT P056 TO CBAKER        DFHEMTP        67 11:24:16  66.3943    .0033    .0031  66.3909    .0000    .0000    .0000
 CEMT P056 TO CBAKER        DFHEMTP       270 11:33:25  62.1072    .0049    .0041  62.1022    .0000    .0000    .0000
 CEMT P056 TO CBAKER        DFHEMTP       235 11:29:00  61.0066    .0015    .0010  61.0051    .0001    .0000    .0000

Example 3: Exclude CICS-supplied system transactions

Note that in the Performance List Extended report shown in Figure 1 some of the worst response times are for the CICS-supplied long running system transactions. So the following command can be used to create a more useful Performance List Extended report as shown in Figure 2 by excluding those types of transactions.

CICSPA LISTX(SELECT(PERFORMANCE(
         EXCLUDE(TRAN(CSHQ,CSNC,CSNE,CSSY,CWXN)))),
         BY(RESPONSE(DESCEND)),
         LIMIT(RESPONSE(20)),
         FIELDS(TRAN,            Transaction ID
                TERM,            Terminal ID
                STYPE,           Start type of transaction
                USERID,          User ID
                RSYSID,          Remote System ID
                PROGRAM,         Initial program name
                TASKNO,          Transaction number
                STOP(TIMES),     Stop time (hh:mm:ss)
                RESPONSE,        Response time
                DISPATCH,        Dispatch time
                CPU,             CPU time
                SUSPEND,         Suspend time
                DISPWAIT,        Dispatch wait time
                FCWAIT,          File Control I/O wait time
                IRWAIT))         Inter-Region (MRO) I/O wait time
Figure 2. Performance List Extended report (filtering using SELECT)
 V5R1M0                                                CICS Performance Analyzer
                                                       Performance List Extended
 
LSTX0001 Printed at 12:03:45  10/15/2012   Data from 11:10:51  2/14/2005 to 11:34:13  2/14/2005              Page       1
 
 Tran Term SC Userid   RSID Program    TaskNo Stop     Response Dispatch User CPU  Suspend DispWait  FC Wait  IR Wait
                                              Time       Time     Time     Time     Time     Time     Time     Time
 CEMT P052 TO CBAKER        DFHEMTP        61 11:23:34  592.514    .1550    .1244  592.359    .0026    .0000    .0000
 CEMT S208 TO BRENNER       DFHEMTP        66 11:20:31  308.883    .0021    .0012  308.881    .0000    .0000    .0000
 CEMT TC32 TO GBURGES       DFHEMTP       597 11:32:06  187.648    .0999    .0741  187.548    .0003    .0000    .0000
 STAT P012 TO CBAKER        DFH0STAT      263 11:33:38  158.917    .2575    .2219  158.659    .0016    .0000    .0000
 CEMT P015 TO CBAKER        DFHEMTP        64 11:16:46  144.153    .0131    .0078  144.140    .0001    .0000    .0000
 CEMT P056 TO CBAKER        DFHEMTP        67 11:20:33  141.000    .0045    .0032  140.996    .0000    .0000    .0000
 CEMT P056 TO CBAKER        DFHEMTP        67 11:22:57  102.494    .0034    .0027  102.490    .0000    .0000    .0000
 CEMT P056 TO CBAKER        DFHEMTP        67 11:18:12  95.0977    .0042    .0035  95.0935    .0000    .0000    .0000
 CEMT P056 TO CBAKER        DFHEMTP        52 11:14:53  81.3172    .0043    .0031  81.3129    .0000    .0000    .0000
 STAT R11  TO CBAKER        DFH0STAT      349 11:22:38  66.7720    .5048    .4620  66.2672    .0007    .0000  65.7887
 CEMT P056 TO CBAKER        DFHEMTP        67 11:24:16  66.3943    .0033    .0031  66.3909    .0000    .0000    .0000
 CEMT P056 TO CBAKER        DFHEMTP       270 11:33:25  62.1072    .0049    .0041  62.1022    .0000    .0000    .0000
 CEMT P056 TO CBAKER        DFHEMTP       235 11:29:00  61.0066    .0015    .0010  61.0051    .0001    .0000    .0000
 STAT P012 TO CBAKER        DFH0STAT      248 11:30:42  52.1363    .0021    .0016  52.1341    .0000    .0000    .0000
 CEDA S23C TO BRENNER       DFHEDAP       137 11:17:27  51.4018   1.1760    .2138  50.2257    .0281    .3115    .0000
 CBAM S23C TO BRENNER       DFHECBAM       43 11:12:50  51.3803    .0607    .0229  51.3196    .0003    .0000    .0000
 CEMT S23D TO BRENNER       DFHEMTP       140 11:21:24  51.3442    .0013    .0010  51.3429    .0000    .0000    .0000
 CEMT P056 TO CBAKER        DFHEMTP        52 11:12:58  50.6951    .0029    .0027  50.6922    .0000    .0000    .0000
 RMST S23D TO BRENNER  CJB3               178 11:22:38  48.9210    .0136    .0012  48.9074    .0000    .0000    .0024

Example 4: Worst internal response time

But now the report is heavily influenced by some of the conversational transactions such as CBAM, CEDA, and CEMT. However, CICS PA provides a solution to this by using a special field name called IRESP (internal response time) which can be used to more easily interpret the actual response time by subtracting the terminal I/O wait time. So the following command will provide a Performance List Extended report sorted in descending order by Internal Response Time as shown in Figure 3.

CICSPA LISTX(SELECT(PERFORMANCE(
         EXCLUDE(TRAN(CSHQ,CSNC,CSNE,CSSY,CWXN)))),
         BY(IRESP(DESCEND)),
         LIMIT(IRESP(20)),
         FIELDS(
                TRAN,            Transaction ID
                TERM,            Terminal ID
                STYPE,           Start type of transaction
                USERID,          User ID
                RSYSID,          Remote System ID
                PROGRAM,         Initial program name
                TASKNO,          Transaction number
                STOP(TIMES),     Stop time (hh:mm:ss)
                RESPONSE,        Response time
                IRESP,           Transaction internal response time
                DISPATCH,        Dispatch time
                CPU,             CPU time
                SUSPEND,         Suspend time
                DISPWAIT,        Dispatch wait time
                TCWAIT,          Terminal Control I/O wait time
                IRWAIT))         Inter-Region (MRO) I/O wait time
Figure 3. Performance List Extended report (sort by IRESP)
 V5R1M0                                                CICS Performance Analyzer
                                                       Performance List Extended
 
LSTX0001 Printed at 12:03:45  10/15/2012 Data from 11:10:51  2/14/2005 to 11:34:13  2/14/2005                      Page       1
 
 Tran Term SC Userid   RSID Program    TaskNo Stop     Response Int Resp Dispatch User CPU  Suspend DispWait  TC Wait  IR Wait
                                              Time       Time     Time     Time     Time     Time     Time     Time     Time
 STAT R11  TO CBAKER        DFH0STAT      349 11:22:38  66.7720  66.7720    .5048    .4620  66.2672    .0007    .0000  65.7887
 CEDA P0AJ TO CBAKER        DFHEDAP       627 11:31:48  43.9778  43.9778    .6774    .1411  43.3004    .0179    .0000    .0000
 CEMT P0AH TO CBAKER        DFHEMTP       603 11:30:16  38.5110  38.5110    .0981    .0190  38.4129    .0113    .0000    .0000
 STAT R11  TO CBAKER        DFH0STAT      132 11:16:47  33.4829  33.4829   1.4544   1.3336  32.0285    .0050    .0000  30.3768
 STAT P0AF TO CBAKER        DFH0STAT      330 11:21:32  22.9057  22.9057    .0508    .0106  22.8549    .0007    .0000    .0000
 CPLT      U  CBAKER        DFHSIPLT        7 11:11:13  20.6297  20.6297    .3608    .0374  20.2689    .0198    .0000    .0000
 CEMT P0AC TO CBAKER        DFHEMTP       217 11:25:38  17.4997  17.4997    .0688    .0111  17.4309    .0018    .0000    .0000
 CPLT      U  CBAKER        DFHSIPLT        7 11:11:07  15.9915  15.9915    .3383    .0369  15.6532    .0155    .0000    .0000
 CEMT P0AG TO CBAKER        DFHEMTP       354 11:21:55  13.3797  13.3797    .1218    .0104  13.2580    .0048    .0000    .0000
 STAT P0AE TO CBAKER        DFH0STAT      292 11:20:12  10.5089  10.5089    .5722    .4729   9.9367    .0031    .0000    .0000
 CEDA P0AJ TO CBAKER        DFHEDAP       686 11:32:03  10.1006  10.1006    .5349    .0849   9.5657    .0073    .0000    .0000
 CALL P056 TO CBAKER        CALLJT1       262 11:30:56   8.2455   8.2452    .0155    .0034   8.2300    .0015    .0003    .0000
 CEMT P0AB TO CBAKER        DFHEMTP       207 11:18:42   4.8000   4.8000    .0885    .0094   4.7115    .0024    .0000    .0000
 TRUE P012 TO CBAKER        CALLCB1       261 11:30:52   4.5463   4.5463    .0017    .0014   4.5445    .0012    .0000    .0000
 CLQ2      U  CBAKER        DFHLUP         28 11:11:13   3.8259   3.8259    .0818    .0068   3.7441    .0035    .0000   3.7344
 CSFU      S  CBAKER        DFHFCU         28 11:11:18   3.7417   3.7417   2.8745    .2291    .8672    .0170    .0000    .0000
 CEMT P0AG TO CBAKER        DFHEMTP       229 11:26:08   3.2382   3.2382    .0470    .0088   3.1912    .0018    .0000    .0000
 CEMT P0AA TO CBAKER        DFHEMTP       127 11:16:03   2.6854   2.6854    .2655    .0161   2.4200    .0016    .0000    .0000
 CEMT P0AC TO CBAKER        DFHEMTP       236 11:19:36   2.5078   2.5078    .0712    .0093   2.4365    .0014    .0000    .0000

Example 5: Worst response times by transaction

Figure 4 shows another example of using the BY, LIMIT, and FIELDS operands to generate a Performance List Extended report sorted in descending order by response time within ascending order by transaction ID. The LIMIT statement will limit the performance class records processed to the first 10 records for each unique transaction ID. The resulting report is in ascending order by transaction ID, with a limit of 10 records for each unique transaction ID. These records will represent the longest response times for each transaction ID.

CICSPA LISTX(
         BY(TRAN(ASCEND),
            RESPONSE(DESCEND)),
         LIMIT(RESPONSE(10)),
         FIELDS(TRAN,            Transaction ID
                RESPONSE,        Response time
                TERM,            Terminal ID
                STYPE,           Start type of transaction
                USERID,          User ID
                RSYSID,          Remote System ID
                PROGRAM,         Initial program name
                TASKNO,          Transaction number
                STOP(TIMES),     Stop time (hh:mm:ss)
                DISPATCH,        Dispatch time
                CPU,             CPU time
                SUSPEND,         Suspend time
                DISPWAIT,        Dispatch wait time
                FCWAIT,          File Control I/O wait time
                IRWAIT))         Inter-Region (MRO) I/O wait time
Figure 4. Performance List Extended report (Top 10 Response Times by Transaction)
 V5R1M0                                          CICS Performance Analyzer
                                                 Performance List Extended
 
LSTX0001 Printed at 12:03:45  10/15/2012     Data from 11:10:51  2/14/2005 to 11:34:13  2/14/2005             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
 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
 AMNU    .0327 P015 TO CBAKER        DFHSAMNU      138 11:16:47     .0270    .0048    .0057    .0056    .0000    .0000
 AMNU    .0228 R11  TO CBAKER        DFHSAMNU      158 11:20:54     .0227    .0012    .0000    .0000    .0000    .0000
 AMNU    .0088 R11  TO CBAKER        DFHSAMNU      203 11:24:10     .0088    .0011    .0000    .0000    .0000    .0000
 AMNU    .0028 S23C TP BRENNER       DFHSAMNU      576 11:27:28     .0012    .0013    .0017    .0000    .0000    .0000
 AMNU    .0027 TC26 TP GBURGES       DFHSAMNU      188 11:22:17     .0026    .0012    .0001    .0000    .0000    .0000
 AMNU    .0026 S23C TP BRENNER       DFHSAMNU      356 11:21:54     .0025    .0013    .0001    .0000    .0000    .0000
 AMNU    .0023 TC26 TO GBURGES       DFHSAMNU      108 11:19:33     .0022    .0011    .0001    .0000    .0000    .0000
 AMNU    .0018 S23C TP BRENNER       DFHSAMNU      566 11:27:14     .0017    .0012    .0001    .0000    .0000    .0000
 AUPD    .0665 S208 TP BRENNER       DFHSAALL       64 11:13:38     .0160    .0141    .0505    .0012    .0000    .0056
 AUPD    .0488 S208 TO BRENNER       DFHSAALL       54 11:12:27     .0335    .0046    .0154    .0153    .0000    .0000
 AUPD    .0321 S208 TO BRENNER       DFHSAALL       57 11:12:34     .0301    .0050    .0019    .0002    .0000    .0016
 AUPD    .0046 S23C TO BRENNER       DFHSAALL      362 11:22:19     .0046    .0014    .0001    .0000    .0000    .0000
 AUPD    .0045 TC26 TO GBURGES       DFHSAALL      141 11:20:25     .0024    .0015    .0021    .0000    .0000    .0020
 AUPD    .0041 TC26 TO GBURGES       DFHSAALL      181 11:21:42     .0025    .0016    .0016    .0000    .0000    .0015
 AUPD    .0030 R11  TO CBAKER        DFHSAALL      205 11:24:20     .0018    .0017    .0012    .0000    .0000    .0012
 AUPD    .0024 TC26 TP GBURGES       DFHSAALL      182 11:21:45     .0023    .0013    .0001    .0000    .0000    .0000
 AUPD    .0022 TC32 TP GBURGES       DFHSAALL      378 11:24:21     .0022    .0012    .0001    .0000    .0000    .0000
 AUPD    .0020 S23C TO BRENNER       DFHSAALL      358 11:22:10     .0019    .0015    .0001    .0000    .0000    .0000
 B       .0031 TC26 TO GBURGES       ########      134 11:19:59     .0031    .0015    .0001    .0000    .0000    .0000
 B       .0024 TC26 TO GBURGES       ########      135 11:19:59     .0024    .0014    .0001    .0001    .0000    .0000

Example 6:

An example of a Cross-System Work Extended report is shown in Figure 5.

The commands to request this report are shown in the following example:
CICSPA IN(SMFIN001),
       LISTX(OUTPUT(CROS0001),
         EXTERNAL(CPAXW001),
         NOPRINTMULTIPLE,PRINTSINGLE,
         BY(UOWID),
         FIELDS(TRAN,                Transaction ID
                RESPONSE,            Response time
                USERID,              User ID
                TASKNO,              Transaction number
                STOP(TIMET),         Stop time (hh:mm:ss.thm)
                DISPATCH(TIME),      Dispatch time
                DISPATCH(COUNT),     Dispatch count
                CPU(TIME),           CPU time
                SUSPEND(TIME),       Suspend time
                SUSPEND(COUNT),      Suspend count
                DISPWAIT(TIME),      Dispatch wait time
                DISPWAIT(COUNT),     Dispatch wait count
                IRWAIT(TIME)))       Inter-Region (MRO) I/O wait time
To use the CICS PA dialog to request this report, specify a LIST or LISTX Report Form for the Cross-System Work report.
Figure 5. Cross-System Work Extended report
 V5R1M0                                                 CICS Performance Analyzer
                                                        Cross-System Work Extended
 
CROS0001 Printed at 12:03:45  10/15/2012 Data from 15:41:19  7/12/2004 to 16:19:15  7/12/2004                           Page       1
 
 Tran Response Userid     TaskNo Stop          Dispatch Dispatch User CPU  Suspend  Suspend DispWait DispWait  IR Wait
        Time                     Time            Time     Count    Time     Time     Count    Time     Count    Time
 CPLT    .3939 CICSUSER        6 15:41:19.419     .0782        3    .0325    .3158        3    .3149        2    .0000
 CSSY  71.4053 CICSUSER      III 15:42:30.828   46.9670      401  17.6543  24.4382      401   9.9254      400    .0000
 CSSY   4.9137 CICSUSER       12 15:41:24.346     .4928       66    .0476   4.4209       66   2.5618       65    .0000
 CSSY   5.3932 CICSUSER       10 15:41:24.822     .8932       59    .2172   4.4999       59   2.7531       58    .0000
 CSSY   5.6419 CICSUSER        9 15:41:25.069    1.6045       75    .1472   4.0374       75   2.9273       74    .0000
 CSSY   5.9801 CICSUSER       13 15:41:25.434     .7826       87    .1627   5.1975       87   3.3042       86    .0000
 CSSY   2.9653 CICSUSER       14 15:41:22.420    1.2597       14    .0555   1.7056       14    .0393       13    .0000
 CSSY    .4372 CICSUSER       15 15:41:19.898     .0037        1    .0034    .4335        1    .0000        0    .0000
 CSSY    .5093 CICSUSER       16 15:41:19.977     .0065        3    .0084    .5028        3    .0103        2    .0000
 CGRP   5.4980 CICSUSER       11 15:41:24.928     .7931       69    .0613   4.7049       69   3.7141       68    .0000
 CSSY   3.3315 CICSUSER       17 15:41:22.805     .0995       37    .0269   3.2321       37   1.3057       36    .0000
 CPLT    .5196 CICSUSER        6 15:41:29.169     .1771        3    .0316    .3425        3    .3422        2    .0000
   . . .

Information Information

Feedback


Timestamp icon Last updated: Friday, 8 February 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//cpaug170.htm