Previous Topic: 3.1.2.5 TSO Command Use Counts

Next Topic: 3.1.2.7 TSO Terminal Ranking

3.1.2.6 TSO User Ranking Report


The TSO User Ranking Report identifies the 'top' or 'bottom'
'n' TSO users by reporting increment (e.g., fifteen minutes)
in any one of the following categories:

    o  Average total response time
    o  Average short response time
    o  Average medium response time
    o  Average long response time
    o  Total response events
    o  Total CPU time
    o  Total EXCPs
    o  Total terminal I/O
    o  Total swaps
    o  Total commands
    o  Total service units
    o  Total transactions

Note:   'Top' means highest numerically
        'Bottom' means lowest numerically

For example, this report can display the three TSO users who
received the highest average short response time in each
fifteen minute reporting interval in a particular time range
on a specific date.

You can use this report to do the following:

     o  Identify those userids consuming the most resources
        in any of twelve categories.
     o  Isolate problem time periods, the userids within that
        period, and the resources each consumed.
     o  Provide a base for evaluating system performance
        changes.
     o  Display the total number of userids existing within
        the reporting increment, even if all are not listed.

Figure 3-12 illustrates a sample TSO User Ranking by Response
Report.


INQUIRY ID:

 TSOLXQ - TSO User Ranking by Response/Time
 TSOLXR - TSO User Ranking by Resource/Activity

DATA SOURCE (File/Timespan):

   TSOTSU - DETAIL

RUNNING THE REPORT

Run this report under MICF, selecting the appropriate
run-time parameters.

 TSOLXQ - TSO User Ranking by Response

   o  database ID to be processed
   o  range of CA MICS file cycles to be processed
   o  ranking by total response time, short response time,
      medium response time, long response time, or CPU time
   o  ranking order:  top or bottom "n" items
   o  number of rankings
   o  user IDs to be included
   o  user IDs to be excluded
   o  terminals to be included
   o  terminals to be excluded
   o  performance group numbers or workload manager service
      classes to be included
   o  performance group numbers or workload manager service
      classes to be excluded
   o  SYSID values to be included
   o  range of dates to be processed
   o  time range to be processed
   o  zone values
   o  report increment in minutes
   o  response distribution limits
      - SHORT response in seconds
      - MEDIUM response in seconds
      - LONG response in seconds
      - TOTAL response in seconds


 TSOLXR - TSO User Ranking by Resource/Activity

   o  database ID to be processed
   o  range of CA MICS file cycles to be processed
   o  ranking by commands, events, EXCPs, terminal
      I/O, transactions, service units, or swaps
   o  ranking order:  top or bottom "n" items
   o  number of rankings
   o  user IDs to be included
   o  user IDs to be excluded
   o  terminals to be included
   o  terminals to be excluded
   o  performance group numbers or workload manager service
      classes to be included
   o  performance group numbers or workload manager service
      classes to be excluded
   o  SYSID values to be included
   o  range of dates to be processed
   o  time range to be processed
   o  zone values
   o  report increment in minutes
   o  response distribution limits
      - SHORT response in seconds
      - MEDIUM response in seconds
      - LONG response in seconds
      - TOTAL response in seconds


                                                  TOP 3 USERS BY TOTAL RESPONSE                                                         YOUR COMPANY NAME INQUIRY:  TSOLXQ                                                                                              RUN DATE:  12JUN08                                                           System = TSOP                                                      For   FEBRUARY 1, 2008 -----------+-------+---+-----+--------------------------------+------------------------------------------------------------------            |       |   |     |                                |TOP LINE IS QUANTITY / BOTTOM LINE IS PCT OF TIME PERIOD TOTAL            |       |   |RESP | RESPONSE AVERAGE / DISTRIBUTION|---------+--------------+--------------+--------+----------------- TIME       |USERID |PGN|EVENT|  TOTAL  SHORT   MEDIUM   LONG  | CPUTIME | EXCPS  TERMIO| SWAPS   CMDS |SERVICE | TRANS ------+----+-------+---+-----+--------------------------------+---------+--------------+--------------+--------+-----------------  8:00- 9:00|       |   |     |                                |         |              |              |        |   59 USERS |ABCX51 |  2|    2| 0:11.46 0:00.00 0:11.46 0:00.00|   0:01.9|    518     26|      2     20|   16252|    18 IN INTERVAL|       |   |     |    0.0%    0.0%    0.0%    0.0%|     0.0%|   0.0%   0.0%|   0.0%   0.1%|    0.0%|   0.0%            |       |   |     |                                |         |              |              |        |            |ABCX67 |  2|    3| 0:10.80 0:00.75 0:00.00 0:30.90|   0:03.1|    901      8|      2     35|   22622|    36            |       |   |     |   66.7%   50.0%    0.0%    0.0%|     0.4%|   1.1%   0.1%|   0.3%   1.7%|    0.3%|   0.9%            |       |   |     |                                |         |              |              |        |            |ABCY20 |  2|   66| 0:10.38 0:00.35 0:02.53 3:19.83|   0:13.5|   4268    132|     26     19|  160113|    68            |       |   |     |   90.9%   91.2%   58.6%    0.0%|     1.9%|   5.0%   2.0%|   4.5%   0.9%|    2.1%|   1.7% -----------+-------+---+-----+--------------------------------+---------+--------------+--------------+--------+-----------------  9:00-10:00|       |   |     |                                |         |              |              |        |   79 USERS |ABCX35 |  2|   66| 0:17.71 0:00.42 0:03.54 8:44.11|   0:33.0|  33875    140|     11     41|  364885|    94 IN INTERVAL|       |   |     |   87.9%   94.1%   43.3%    0.0%|     3.5%|  17.3%   1.2%|   0.8%   0.8%|    4.1%|   1.4%            |       |   |     |                                |         |              |              |        |            |ABCY22 |  2|    4| 0:12.96 0:00.01 0:14.20 0:23.45|   0:04.1|   1185     18|      7     30|   35185|    34            |       |   |     |   25.0%  100.0%    0.0%    0.0%|     0.4%|   0.6%   0.2%|   0.5%   0.6%|    0.4%|   0.5%            |       |   |     |                                |         |              |              |        |            |ABCY79 |  2|  199| 0:08.28 0:00.26 0:04.22 3:38.79|   2:44.2|  38814    414|     15    102| 1704513|   256            |       |   |     |   94.0%   93.7%   29.4%    0.0%|    17.5%|  19.9%   3.5%|   1.2%   1.9%|   19.1%|   3.9% -----------+-------+---+-----+--------------------------------+---------+--------------+--------------+--------+----------------- 10:00-11:00|       |   |     |                                |         |              |              |        |   81 USERS |ABCX57 |  2|   40| 0:09.70 0:00.55 0:02.80 0:21.33|   1:46.3|   2024     86|     21      7| 1123294|    44 IN INTERVAL|       |   |     |   67.5%   77.8%   46.7%   37.5%|     9.6%|   1.3%   0.7%|   1.7%   0.2%|   10.3%|   0.7%            |       |   |     |                                |         |              |              |        |            |ABCY06 |  2|   76| 0:08.18 0:00.31 0:02.52 0:18.18|   2:17.3|   4549    176|     18     21| 1526078|    90            |       |   |     |   72.4%   88.9%   60.7%   46.7%|    12.4%|   3.0%   1.5%|   1.4%   0.6%|   14.0%|   1.5%            |       |   |     |                                |         |              |              |        |            |ABCX47 |  2|  102| 0:05.17 0:00.54 0:01.00 0:17.67|   2:31.4|   3766    226|     45     14| 1640028|   113            |       |   |     |   84.3%   76.4%   80.0%   40.7%|    13.7%|   2.5%   1.9%|   3.6%   0.4%|   15.1%|   1.9% -----------+-------+---+-----+--------------------------------+---------+--------------+--------------+--------+----------------- --------------------------------------------------------------------------------------------------------------------------------- DATES=NONE,TIME=(08:00-17:00),INCREMENT=60,TOTAL=5.00,SHORT=1.00,MEDIUM=2.00,LONG=5.00



 Figure 3-12.  TSO User Ranking Report