SirAud report contents: Difference between revisions

From m204wiki
Jump to navigation Jump to search
m (misc cleanup)
 
m (add examples)
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Overview==
==PERFREPT==
Each line in a PERFREPT report corresponds to a
Each line in a PERFREPT report corresponds to a
partial interval as defined by the ACCTIM parameter.
partial interval as defined by the <var>[[ACCTIM parameter|ACCTIM]]</var> parameter.
The columns in the report are derived from the information in the system partial
The columns in the report are derived from the information in the system partial
statistics entries, since last statistics entries for CMPL, LOAD, and
statistics entries, since-last statistics entries for CMPL, LOAD, and EVAL activities, and user logout statistics entries.
EVAL activities, and user logout statistics entries.
Unless otherwise noted, statistics values come from the system partial statistics entry.
Unless otherwise noted, statistics values come from the system partial statistics entry.
<table class="thJustBold">
<table>
<caption>PERFREPT column headings</caption>
<tr class="head"><th>Column</th><th>Content</th></tr>
<tr class="head"><th>Column</th><th>Content</th></tr>


<tr><th>DATE</th>
<tr><td>DATE</td>
<td>The date when the statistics for the interval were logged to the journal.</td></tr>
<td>The date when the statistics for the interval were logged to the journal.</td></tr>


<tr><th>END OF INTVL</th>
<tr><td>END OF INTVL</td>
<td>The time when the statistics for the interval were logged to the journal.</td></tr>
<td>The time when the statistics for the interval were logged to the journal.</td></tr>


<tr><th>AVG USERS</th>
<tr><td>AVG USERS</td>
<td>The connect time (CNCT) used by all logged in users during the interval, divided by the seconds in the interval. The connect time for a user is reported in the user partial and logout statistics entries.</td></tr>
<td>The connect time (CNCT) used by all logged in users during the interval, divided by the seconds in the interval. The connect time for a user is reported in the user partial and logout statistics entries.</td></tr>


<tr><th>%CPU</th>
<tr><td>%CPU</td>
<td>The CPU value divided by the CNCT value.</td></tr>
<td>The CPU value divided by the CNCT value.</td></tr>


<tr><th>PCPU</th>
<tr><td>PCPU</td>
<td>The PCPU value reported for the interval
<td>The PCPU value reported for the interval when <var class="product">Model 204</var> is running on a single CPU.
when <var class="product">Model 204</var> is running on a single CPU.
<p>
When MP is active and offload subtask partial statistics are produced, the PCPU for the interval is the CPU for the interval divided by the PR for the interval.</td></tr>
When [[MP/204|MP]] is active and offload subtask partial statistics are produced, the PCPU for the interval is the CPU for the interval divided by the PR for the interval.</p></td></tr>


<tr><th>SCREENS/SEC, DKRD+DKWR/SEC, SVRD+SVWR/SEC, LKWAIT+LKPOST/SEC</th>
<tr><td>SCREENS/SEC <br>DKRD/SEC <br>DKWR/SEC  <br>DKWR-DKAW/SEC <br>SVRD+SVWR/SEC <br>LKWAIT+LKPOST/SEC</td>
<td>The statistics or sum of statistics, divided by the number of seconds in the interval.</td></tr>
<td>The statistics or sum of statistics, divided by the number of seconds in the interval.</td></tr>


<tr><th>JRNL I/O/SEC</th>
<tr><td>JRNL I/O/SEC</td>
<td>The number of blocks written during the interval, divided by the number of seconds in the interval.</td></tr>
<td>The number of blocks written during the interval, divided by the number of seconds in the interval.</td></tr>


<tr><th>RESP TIME SECS/SCRN MEAN</th>
<tr><td>RESP TIME SECS/SCRN MEAN</td>
<td>The mean response time in seconds per screen over the interval.
<td>The mean response time in seconds per screen over the interval.
Sample points for determining the mean are gathered from the user since last statistics entries.
Sample points for determining the mean are gathered from the user since-last statistics entries.
Each execution of a procedure is accompanied by a CMPL/EVAL or LOAD/EVAL since last pair.
Each execution of a procedure is accompanied by a CMPL/EVAL or LOAD/EVAL since-last pair.
<p>
<p>
The RQTM statistic reported in the since last entries is summed for a user until an EVAL since last entry is found that has
The RQTM statistic reported in the since-last entries is summed for a user until an EVAL since-last entry is found that has a SCREENS value not equal 0. A sample point is then determined by taking the RQTM sum and dividing it by SCREENS. In the case when a partial interval completes and a sample point is in progress (no EVAL with SCREENS not equal 0 found yet), the sample point is determined using the RQTM sum through the last EVAL and dividing it by 1. </p>
a SCREENS value not equal 0.
<p>
A sample point is then determined by taking the RQTM sum and dividing it by SCREENS.
The RQTM from the last CMPL or LOAD since-last entry is attributed to the next partial interval.</p></td></tr>
In the case when a partial interval completes and a sample point is in progress (no EVAL with SCREENS not equal 0 found yet), the sample point is determined using the RQTM sum through the last EVAL and dividing it by 1.
The RQTM from the last CMPL or LOAD since last entry is attributed to the next partial interval.</p></td></tr>


<tr><th>RESP TIME SECS/SCRN STDEV</th>
<tr><td nowrap>RESP TIME SECS/SCRN STDEV</td>
<td>The standard deviation of the response time in seconds per screen over the interval. Sample points for determining the standard deviation are the same as with the mean.</td></tr>
<td>The standard deviation of the response time in seconds per screen over the interval. Sample points for determining the standard deviation are the same as with the mean.</td></tr>


<tr><th>CPU SECS/SCRN MEAN</th>
<tr><td>CPU SECS/SCRN MEAN</td>
<td>The mean CPU time used in seconds per screen. Sample points for determining the mean are calculated the same way as for the mean response time, except that the CPU statistic is used instead of RQTM.</td></tr>
<td>The mean CPU time used in seconds per screen. Sample points for determining the mean are calculated the same way as for the mean response time, except that the CPU statistic is used instead of RQTM.</td></tr>


<tr><th>CPU SECS/SCRN STDEV</th>
<tr><td>CPU SECS/SCRN STDEV</td>
<td>The standard deviation of the CPU time used in seconds per screen over the interval. Sample points for determining the standard deviation are the same as with the mean.</td></tr>
<td>The standard deviation of the CPU time used in seconds per screen over the interval. Sample points for determining the standard deviation are the same as with the mean.</td></tr>


<tr><th>DKRD+DKWR/SCRN, SVRD+SVWR/SCRN</th>
<tr><td>SVRD+SVWR/SCRN</td>
<td>Those statistics values divided by the SCREENS for the interval.</td></tr>
<td>Those statistics values divided by the SCREENS for the interval.</td></tr>
</table>
</table>
<b>Example</b>
An example follows:
<p class="code" style="font-size: 85%;  padding: 1px">SIRAUD  1.05 - <b>PERFREPT</b> -  INTERVAL PERFORMANCE REPORT FROM: Sample ONLINE  09/07/16 08:06:18-09/07/16 09:48:11  1
DATE    END        AVG  % CPU STCPU PCPU SCREENS    DKRD    DKWR    DKWR  JRNL  LKWAIT      RESP TIME            CPU        SVRD
            OF      USERS        /CPU                                -DKAW    I/O +LKPOST      SECS/SCRN        SECS/SCRN    +SVWR
            INTVL                            /SEC    /SEC    /SEC    /SEC  /SEC    /SEC    MEAN    STDEV    MEAN    STDEV  /SCRN
09/07/16 08:06:32    0.0  0.0  0.00  589    0.00    0.14    0.07    0.07  0.00    0.0    0.000    0.000    0.000    0.000  0.00
09/07/16 08:15:00    0.4  11.2  0.41  925    0.00  165.30    2.08    2.08  2.85    0.0    2.105    8.400    1.024    5.752  0.00
09/07/16 08:30:00  1231.9 103.6  0.34  966  190.10 2021.13  349.21  322.74  48.16    6.4    0.084    3.796    0.004    0.078  0.22
09/07/16 08:45:00  5581.5  76.6  0.22  983  187.62 1528.29  302.55  279.81  39.61    1.7    0.125    6.661    0.003    0.099  0.21
09/07/16 09:00:00  6440.3  67.2  0.18  975  177.51 1411.38  298.18  279.45  39.79    0.8    0.203    6.377    0.002    0.024  0.20
09/07/16 09:15:00  6490.0 111.8  0.32  983  171.04 1411.90  304.08  281.03  39.82    2.4    0.243    7.044    0.005    0.046  0.21
09/07/16 09:30:00  6436.4 136.0  0.37  977  181.70 1521.28  315.99  288.76  42.59    2.9    0.172    7.310    0.006    0.056  0.21
09/07/16 09:45:00  6264.8 104.6  0.29  983  151.87 1224.76  306.48  290.33  42.62    1.5    0.192    7.706    0.004    0.039  0.23
09/07/16 09:48:11 14574.8  3.4  0.26  981    0.15    3.54    6.37    6.37  2.61    0.0    4.857  138.976    0.001    0.027 572.89</p>


==FILEREPT==
==FILEREPT==
Line 61: Line 77:
totalled for each file and for all files.
totalled for each file and for all files.
The <var class="product">Model&nbsp;204</var> files are listed in descending order by the sum of the DKRD and DKWR columns.
The <var class="product">Model&nbsp;204</var> files are listed in descending order by the sum of the DKRD and DKWR columns.
<table class="thJustBold">
<table>
<tr class="head"><th>Column</th><th>Content</th></tr>
<caption>FILEREPT column headings</caption>
<tr class="head"><th>Column</th>
<th>Content</th></tr>
 
<tr><td>FILE NAME</td>
<td>The name of the <var class="product">Model 204</var> file. The first line of the report presents the totals for all <var class="product">Model&nbsp;204</var> files and uses <code>*TOTALS*</code> as the name.</td></tr>
 
<tr><td>DKRD <br>DKWR <br>DKUPDT <br>DIRRCD <br>BXFIND <br>BXNEXT <br>BXRFND <br>BADD+BDEL+BCHG <br>IXADD+IXDEL <br>RECADD+RECDEL <br>BXINSE+BXDELE+BXCHNG <br>RETRYC</td>
<td>The totals of the specified statistic or sum of statistics.
<p class="note"><b>Note:</b>
DKUPDT is the number of times pages from the file were flushed out of the buffer pool. </p></td></tr>
</table>


<tr><th>FILE NAME</th>
<b>Example</b>
<td>The name of the <var class="product">Model 204</var> file. The first line of the report presents the totals for all <var class="product">Model 204</var> files and uses *TOTALS* as the name.</td></tr>


<tr><th>DKRD, DKWR, DIRRCD, BXFIND, BXNEXT, BXRFND, BADD+BDEL+BCHG, IXADD+IXDEL, RECADD+RECDEL, BXINSE+BXDELE+BXCHNG, RETRYC</th>
An example follows:
<td>The totals of the specified statistic or sum of statistics.</td></tr>


<tr><th>DKUPDT</th>
<p class="code" style="font-size: 85%;  padding: 1px">SIRAUD  1.05 - <b>FILEREPT</b> -    SIGNIFICANT FILE REPORT  FROM: Sample ONLINE  09/07/16 08:06:18-09/07/16 09:48:11  1
<td>The number of times pages from the file were flushed out of the buffer pool.</td></tr>
FILE          DKRD      DKWR    DKUPDT  DIRRCD    BXFIND    BXNEXT    BXRFND  BADD+BDEL    IXADD    RECADD BXINSE+    RETRYC
</table>
NAME                                                                                    +BCHG    +IXDEL  +RECDEL BXDELE+BXCHNG
&#42;TOTALS*    8291409    1691152    157803    35514  59150986  269324351    2765067    7125855      233    76197    563660      0
ABCDECT0    221550    126562        0        0    222498          0          0    564399        0        27    194583      0
ABCDESY0    231992    102849        0        0    4070893    3167243      22733    1604339        0      4798      31470      0
ABCDESR0    189901      45136        0        0    383258      7089      7086    242045        0      150        267      0
ABCDEFF0    203121      8877        0        0    676491      74147        630      21041        0      453      1767      0
ABCDEM30      28541    180728        0        0    104283        40          0    221588        0      8020      30695      0
ABCDEM40      28110    180945        0        0    105010        36          0    223008        0      8076      32041      0
ABCDETM0    185174      23169        0        0    506850          0          0      88919        0        4      7447      0
ABCDEM20      28138    179854        0        0    104349        44          0    221552        0      8025      32045      0
ABCDERE0    159048      48564        0        0    2259576          0          0    108318        0        2      12148      0
ABCDEM10      28224    179352        0        0    103973        48          0    220841        0      7996      31845      0
</p>


==PROCREPT==
==PROCREPT==
One logical line is produced for each unique
One logical line is produced for each unique combination of procedure name, procedure file name, and subsystem name executed during the <var class="product">Model&nbsp;204</var> run, and a summation line is produced for all procedures executed.
combination of procedure name, procedure file name, and subsystem name
Each logical line requires two physical lines: the report is divided into two, stacked, listings.
executed during the <var class="product">Model 204</var> run, and a summation line is produced for all procedures executed.
Each logical line requires two physical lines.


The columns are derived from user since last statistics entries for CMPL,
The columns are derived from user since-last statistics entries for CMPL,
LOAD, or EVAL activities.
LOAD, or EVAL activities.
The procedures are sorted in descending order by <code>TOTAL CPU SECONDS</code>.
The procedures are sorted in descending order by <code>TOTAL CPU SECS</code>. The first output line below the column headings begins with <code>*TOTALS*</code> and presents the totals for all procedures executed.
<table class="thJustBold">
 
<tr class="head"><th>Column</th><th>Content</th></tr>
<table>
<caption>PROCREPT column headings</caption>
<tr class="head"><th>Column</th>
<th>Content</th></tr>


<tr><th>RANK</th>
<tr><td>RANK</td>
<td>The rank of the procedure by TOTAL CPU SECONDS.</td></tr>
<td>The rank (integer) of the procedure by <code>TOTAL CPU SECS</code>.</td></tr>


<tr><th>PROCEDURE NAME</th>
<tr><td>PROCEDURE NAME</td>
<td>The name of the procedure.</td></tr>
<td>The name of the procedure.</td></tr>


<tr><th>PROC FILE</th>
<tr><td>PROC FILE</td>
<td>The name of the file to which the procedure belongs.</td></tr>
<td>The name of the file to which the procedure belongs.</td></tr>


<tr><th>SUBSYSTEM NAME</th>
<tr><td>SUBSYSTEM NAME</td>
<td>The name of the subsystem to which the procedure file belongs.</td></tr>
<td>The name of the subsystem to which the procedure file belongs.</td></tr>


<tr><th>NUMBER OF RUNS</th>
<tr><td>NUMBER OF RUNS</td>
<td>The number of times a procedure was executed.</td></tr>
<td>The number of times a procedure was executed.</td></tr>


<tr><th>TOTAL CPU SECS</th>
<tr><td>TOTAL CPU SECS</td>
<td>The total CPU from the CMPL, LOAD, and EVAL since last entries converted from milliseconds to seconds.</td></tr>
<td>The total CPU from the CMPL, LOAD, and EVAL since-last entries converted from milliseconds to seconds.</td></tr>


<tr><th>EVAL CPU SECS</th>
<tr><td>EVAL CPU SECS</td>
<td>The total CPU from EVAL since last entries converted from milliseconds to seconds.</td></tr>
<td>The total CPU from EVAL since-last entries converted from milliseconds to seconds.</td></tr>


<tr><th>STCPU/CPU</th>
<tr><td>STCPU/CPU</td>
<td>The sum of all STCPU divided by the sum of all CPU.</td></tr>
<td>The sum of all STCPU divided by the sum of all CPU.</td></tr>


<tr><th>RESP TIME MEAN</th>
<tr><td>RESP TIME MEAN</td>
<td>The mean response time in seconds per procedure run. An execution of a procedure is accompanied by a CMPL/EVAL or LOAD/EVAL since last pair, and it determines a sample point for calculating the mean response time.
<td>The mean response time in seconds per procedure run. An execution of a procedure is accompanied by a CMPL/EVAL or LOAD/EVAL since-last pair, and it determines a sample point for calculating the mean response time.
<p>
<p>
<var class="product">SirAud</var> assigns a variable known as RUNIN to each run. RUNIN is set to the SCREENS from the EVAL since last entry, if SCREENS is not equal to 0.
<var class="product">SirAud</var> assigns a variable known as <code>RUNIN</code> to each run. <code>RUNIN</code> is set to the SCREENS from the EVAL since-last entry, if SCREENS is not equal to 0.
Otherwise, RUNIN is set to the IN from the EVAL since-last entry, if IN is not equal 0. Otherwise, RUNIN is set to 1.</p>
Otherwise, <code>RUNIN</code> is set to the IN from the EVAL since-last entry, if IN is not equal 0. Otherwise, <code>RUNIN</code> is set to 1.</p>
<p>
<p>
The RQTM statistic from the CMPL or LOAD since last entry is added to the RQTM from the EVAL.
The RQTM statistic from the CMPL or LOAD since-last entry is added to the RQTM from the EVAL.
A sample point is then determined by taking the RQTM sum and dividing it by RUNIN.</p></td></tr>
A sample point is then determined by taking the RQTM sum and dividing it by <code>RUNIN</code>. </p></td></tr>


<tr><th>RESP TIME STDEV</th>
<tr><td>RESP TIME STDEV</td>
<td>The standard deviation of the response time in seconds per procedure run. Sample points for determining the standard deviation are the same as with the mean.</td></tr>
<td>The standard deviation of the response time in seconds per procedure run. Sample points for determining the standard deviation are the same as with the mean.</td></tr>


<tr><th>TOTAL DKRD+DKWR, TOTAL BXFIND, <br>TOTAL BXNEXT</th>
<tr><td>TOTAL DKRD+DKWR <br>TOTAL BXFIND <br>TOTAL BXNEXT</td>
<td>The totals of the specified statistic or sum of statistics.</td></tr>
<td>The totals of the specified statistic or sum of statistics.</td></tr>


<tr><th>UPDATE UNIT SECS MEAN</th>
<tr><td>UPDATE UNIT SECS MEAN</td>
<td>The mean time in seconds an update unit was active for the procedure. A sample point is the time between the start and end of an update unit.</td></tr>
<td>The mean time in seconds an update unit was active for the procedure. A sample point is the time between the start and end of an update unit.</td></tr>


<tr><th>UPDATE UNIT SECS STDEV</th>
<tr><td>UPDATE UNIT SECS STDEV</td>
<td>The standard deviation of the number of seconds seconds an update unit was active for the procedure. Sample points for determining the standard deviation are the same as with the mean.</td></tr>
<td>The standard deviation of the number of seconds seconds an update unit was active for the procedure. Sample points for determining the standard deviation are the same as with the mean.</td></tr>


<tr><th>NUMBER OF SCREENS</th>
<tr><td nowrap>NUMBER OF SCREENS</td>
<td>The total SCREENS for the totals line. The sum of the RUNIN variable for a procedure is used for an individual procedure.</td></tr>
<td>The total SCREENS for the totals line. The sum of the RUNIN variable for a procedure is used for an individual procedure.</td></tr>


<tr><th>AVERAGE CPU SECS</th>
<tr><td>AVERAGE CPU SECS</td>
<td>The total CPU divided by NUMBER OF SCREENS, then converted from milliseconds to seconds. All other "AVERAGE" columns are the total of the specified statistic divided by NUMBER OF SCREENS.</td></tr>
<td>The total CPU divided by <code>NUMBER OF SCREENS</code>, then converted from milliseconds to seconds. All other "AVERAGE" columns are the total of the specified statistic divided by <code>NUMBER OF SCREENS</code>.</td></tr>


<tr><th>AVERAGE DKRD+DKWR, AVERAGE DKPR, AVERAGE SVRD+SVWR, AVERAGE STDEQ, AVERAGE FINDS, AVERAGE DIRRCD, AVERAGE RECDS, AVERAGE SORTS, AVERAGE STRECDS</th>
<tr><td nowrap>AVERAGE DKRD+DKWR <br>AVERAGE DKPR <br>AVERAGE SVRD+SVWR <br>AVERAGE STDEQ <br>AVERAGE FINDS <br>AVERAGE DIRRCD <br>AVERAGE RECDS <br>AVERAGE SORTS <br>AVERAGE STRECDS</td>
<td>The totals of the specified statistic or sum of statistics divided by NUMBER OF SCREENS.</td></tr>
<td>The totals of the specified statistic or sum of statistics divided by <code>NUMBER OF SCREENS</code>.</td></tr>
</table>
</table>
<b>Example</b>
An example follows:
<p class="code" style="font-size: 85%;  padding: 1px">SIRAUD  1.05 - <b>PROCREPT</b> - SIGNIFICANT PROCEDURE REPORT FROM: Sample ONLINE  09/07/16 08:06:18-09/07/16 09:48:11  1
RANK PROCEDURE              PROC    SUBSYSTEM  NUMBER    TOTAL      EVAL STCPU      RESP      RESP    TOTAL    TOTAL    TOTAL
      NAME                    FILE    NAME            OF      CPU      CPU  /CPU      TIME      TIME      DKRD    BXFIND    BXNEXT
                                                    RUNS      SECS      SECS            MEAN    STDEV    +DKWR
    *TOTALS*                                    4601380  4641.543  4289.448  0.33    7.504  125.349  9591782  58915232 229796276
    1 PROCANYOLD19            MYPRFILE SMPOW        7353  1427.525  1427.520  0.35    3.027    5.096    80412    131271    90888
    2 PROCANYOLD06            MYPRFILE SMPAC      399987  130.461  130.051  0.25    2.528    4.627    10789    611591        0
    3 PROCANYOLD02            MYPRFILE SMPAC        3020  120.147  119.935  0.29    2.735    4.748    68433  7398922        0
    4 PROCANYOLD18            MYPRFILE SMPAIN      25657  111.540  111.492  0.24    2.612    4.780    36707    784129        0
    5 PROCANYOLD11            MYPRFILE SMPOUR        1845    83.539    83.491  0.33    6.832    64.613    871863  3326283    29125
    6 PROCANYOLD04            MYPRFILE SMPELT      204572    78.692    78.541  0.29    2.508    4.628      733        0        0
    7 PROCANYOLD03            MYPRFILE SMPAIN        7642    76.744    76.053  0.37    2.621    4.628    66317    493667        0
    8 PROCANYOLD15            MYPRFILE SMPAC        14091    76.301    76.004  0.28    2.658    4.729    169199    458538        0
    9 PROCANYOLD10            MYPRFILE SMPAIN        7582    74.913    74.622  0.26    2.629    4.817      7545    322669        0
  10 PROCANYOLD01            MYPRFILE SMPAC      196105    56.475    55.964  0.25    2.505    4.620    43634  2607794        0
RANK  UPDATE UNIT SECS    NUMBER  AVERAGE  AVERAGE  AVERAGE  AVERAGE  AVERAGE  AVERAGE  AVERAGE  AVERAGE  AVERAGE  AVERAGE
        MEAN    STDEV        OF      CPU      DKRD      DKPR      SVRD    STDEQ    FINDS    DIRRCD    RECDS    SORTS  STRECDS
                          SCREENS      SECS    +DKWR              +SVWR
        0.000    0.000    879215    0.005      10.9    1228.6      0.1      9.77      20.9      0.0    2011.7      0.0      1.3
    1    0.000    0.000      7353    0.194      10.9  10964.9      0.0    78.52      30.4      0.0  229990.1      0.0      0.0
    2    0.000    0.000    203877    0.000      0.0      6.7      0.0      0.38      1.5      0.0      1.0      0.0      0.0
    3    0.000    0.000        0    0.039      22.6    9937.2      0.0    16.32    342.4      0.0    394.5      0.0      0.0
    4    0.000    0.000        0    0.004      1.4    2716.8      0.0      0.88      18.1      0.0    462.1      0.0      0.0
    5    0.000    0.000      2536    0.032    343.7  16233.6      0.1    96.40    335.7      0.0    235.2      0.0      0.0
    6    0.000    0.000        0    0.000      0.0      0.0      0.0      0.29      0.0      0.0      0.0      0.0      0.0
    7    0.000    0.000        0    0.010      8.6    1731.7      0.0    11.97      21.2      3.3      39.6      0.0      0.0
    8    0.000    0.000        0    0.005      12.0    2729.2      0.0      4.83      19.5      0.0    461.0      0.0      0.0
    9    0.000    0.000        0    0.009      0.9    663.1      0.0      1.24      21.2      0.0      68.5      0.0      0.0
  10    0.000    0.000        0    0.000      0.2      81.3      0.0      0.39      10.9      0.0      15.3      0.0      0.0
</p>


==SUBREPT==
==SUBREPT==
There is one line produced for each subsystem that
There is one line produced for each subsystem that
was active during the <var class="product">Model&nbsp;204</var> run and a summation line for all subsystems that were active.
was active during the <var class="product">Model&nbsp;204</var> run and a summation line for all subsystems that were active.
The columns are derived from user since last statistics entries for CMPL, LOAD, or EVAL activities for member procedures.
The columns are derived from user since-last statistics entries for CMPL, LOAD, or EVAL activities for member procedures.
The subsystems are sorted in descending order by TOTAL CPU SECONDS.
 
<table class="thJustBold">
The subsystems are sorted in descending order by <code>TOTAL CPU SECS</code>. The first output line below the column headings begins with <code>*TOTALS*</code> and presents the totals for all active subsystems.
<tr class="head"><th>Column</th><th>Content</th></tr>
<table>
<caption>SUBREPT column headings</caption>
<tr class="head"><th>Column</th>
<th>Content</th></tr>


<tr><th>SUBSYSTEM NAME</th>
<tr><td>SUBSYSTEM NAME</td>
<td>The name of the subsystem. The first line of the report presents the totals for all subsystems and uses *TOTALS* as the name. *NONE* is used for reporting on procedures that were run outside of subsystem context.</td></tr>
<td>The name of the subsystem. The first line of the report presents the totals for all subsystems and uses <code>*TOTALS*</code> as the name. <code>*NONE*</code> is used for reporting on procedures that were run outside of subsystem context.</td></tr>


<tr><th>TOTAL CPU SECS</th>
<tr><td>TOTAL CPU SECS</td>
<td>The total CPU from the CMPL, LOAD, and EVAL since last entries converted from milliseconds to seconds.</td></tr>
<td>The total CPU from the CMPL, LOAD, and EVAL since-last entries converted from milliseconds to seconds.</td></tr>


<tr><th>EVAL CPU SECS</th>
<tr><td>EVAL CPU SECS</td>
<td>The total CPU from EVAL since last entries converted from milliseconds to seconds.</td></tr>
<td>The total CPU from EVAL since-last entries converted from milliseconds to seconds.</td></tr>


<tr><th>STCPU/CPU</th>
<tr><td>STCPU/CPU</td>
<td>The sum of all STCPU divided by the sum of all CPU.</td></tr>
<td>The sum of all STCPU divided by the sum of all CPU.</td></tr>


<tr><th>TOTAL DKRD+DKWR, TOTAL SVRD+SVWR</th>
<tr><td>TOTAL DKRD+DKWR <br>TOTAL SVRD+SVWR</td>
<td>The total of the specified statistics sums.</td></tr>
<td>The total of the specified sums of statistics.</td></tr>


<tr><th>NUMBER OF SCREENS</th>
<tr><td nowrap>NUMBER OF SCREENS</td>
<td>The total SCREENS from EVAL since last entries.</td></tr>
<td>The total SCREENS from EVAL since-last entries.</td></tr>


<tr><th>NUMBER OF RUNS</th>
<tr><td>NUMBER OF RUNS</td>
<td>The number of times member procedures were executed.</td></tr>
<td>The number of times member procedures were executed.</td></tr>


<tr><th>RESP TIME MEAN</th>
<tr><td>RESP TIME MEAN</td>
<td>The mean response time in seconds per member procedure run. An execution of a member procedure is accompanied by a CMPL/EVAL or LOAD/EVAL since last pair, and it determines a sample point for calculating the mean response time.
<td>The mean response time in seconds per member procedure run. An execution of a member procedure is accompanied by a CMPL/EVAL or LOAD/EVAL since-last pair, and it determines a sample point for calculating the mean response time.
<p>
<p>
<var class="product">SirAud</var> assigns a variable known as RUNIN to each run. RUNIN is set to the SCREENS from the EVAL since last entry, if SCREENS is not equal 0.
<var class="product">SirAud</var> assigns a variable known as <code>RUNIN</code> to each run. <code>RUNIN</code> is set to the SCREENS from the EVAL since-last entry, if SCREENS is not equal 0.
Otherwise, RUNIN is set to the IN from the EVAL since last entry, if IN is not equal 0. Otherwise, RUNIN is set to 1. </p>
Otherwise, <code>RUNIN</code> is set to the IN from the EVAL since-last entry, if IN is not equal 0. Otherwise, <code>RUNIN</code> is set to 1. </p>
<p>
<p>
The RQTM statistic from the CMPL or LOAD since last entry is added to the RQTM from the EVAL. A sample point is then determined by taking the RQTM sum and dividing it by RUNIN.</p></td></tr>
The RQTM statistic from the CMPL or LOAD since-last entry is added to the RQTM from the EVAL. A sample point is then determined by taking the RQTM sum and dividing it by <code>RUNIN</code>.</p></td></tr>


<tr><th>RESP TIME STDEV</th>
<tr><td>RESP TIME STDEV</td>
<td>The standard deviation of the response time in seconds per member procedure run. Sample points for determining the standard deviation are the same as with the mean.</td></tr>
<td>The standard deviation of the response time in seconds per member procedure run. Sample points for determining the standard deviation are the same as with the mean.</td></tr>


<tr><th>CPU SECS/SCRN</th>
<tr><td>CPU SECS/SCRN</td>
<td>CPU converted to seconds from milliseconds and divided by SCREENS. All other "/SCRN" columns are the statistic value divided by SCREENS.</td></tr>
<td>CPU converted to seconds from milliseconds and divided by <code>NUMBER OF SCREENS</code>. All other "/SCRN" columns are the statistic value divided by <code>NUMBER OF SCREENS</code>.</td></tr>


<tr><th>DKRD+DKWR/SCRN, SVRD+SVWR/SCRN</th>
<tr><td>DKRD+DKWR/SCRN <br>SVRD+SVWR/SCRN</td>
<td>Sums of statistics divided by the SCREENS.</td></tr>
<td>Sums of statistics divided by <code>NUMBER OF SCREENS</code>.</td></tr>


<tr><th>SERVER SIZE (K)</th>
<tr><td>SERVER SIZE (K)</td>
<td>The smallest server size, in units of 1024 bytes, needed to execute the member procedures without any UTABLE commands. A server is made up of a fixed portion, determined by <var class="product">Model 204</var> user initialization parameters (for example, LOBUFF) that are fixed during the run, and a variable portion containing tables that can be resized using a UTABLE command.
<td>The smallest server size, in units of 1024 bytes, needed to execute the member procedures without any <var>[[UTABLE command|UTABLE]]</var> commands. A server is made up of a fixed portion, determined by <var class="product">Model&nbsp;204</var> user initialization parameters (for example, <var>[[LOBUFF parameter|LOBUFF]]</var>) that are fixed during the run, and a variable portion containing tables that can be resized using a <var>UTABLE</var> command.
The size calculated for this column is based on the member procedures that were actually executed during the run. See [[#utrep|UTBLREPT]] for a more detailed explanation.</td></tr>
<p>
The size calculated for this column is based on the member procedures that were actually executed during the run. See [[#utrep|UTBLREPT]] for a more detailed explanation. </p></td></tr>
</table>
</table>
<b>Example</b>
An example follows:
<p class="code" style="font-size: 85%;  padding: 1px">SIRAUD  1.05 - <b>SUBREPT</b>  - SIGNIFICANT SUBSYSTEM REPORT FROM: Sample ONLINE  09/07/16 08:06:18-09/07/16 09:48:11  1
SUBSYSTEM      TOTAL      EVAL  STCPU    TOTAL    TOTAL  NUMBER  NUMBER      RESP      RESP      CPU      DKRD      SVRD SERVER
  NAME          CPU      CPU  /CPU      DKRD      SVRD      OF      OF      TIME      TIME      SECS    +DKWR    +SVWR  SIZE
                SECS      SECS            +DKWR    +SVWR  SCREENS    RUNS      MEAN    STDEV    /SCRN    /SCRN    /SCRN    (K)
*TOTALS*    4641.543  4289.448  0.33  9591782    127838  879215  4601380      7.50    125.34    0.005      10.9      0.1  3161
SMPOW      1601.074  1598.362  0.34    727849        0  182451  397647      2.47      4.63    0.008      3.9      0.0  1561
SMPAC        998.246  962.947  0.29  2041595        0  204063  1237058      2.54      4.65    0.004      10.0      0.0  2443
SMPOUR      886.205  791.923  0.38  4040404    88416  326239  526603    46.23    367.69    0.002      12.3      0.2  3136
SMPAIN      653.442  581.958  0.31    909909        2        0  947275      2.54      4.63    0.000      0.0      0.0  2994
SMPUTT      253.276  155.595  0.33    684889    37686  134098  224448      2.30      4.87    0.001      5.1      0.2  3076
SMPELT      107.607  107.432  0.33      1864        0      449  826040      2.48      4.61    0.239      4.1      0.0    498
SMPAN        48.323    16.606  0.37    57644        0        0    15368      0.19      0.73    0.000      0.0      0.0  2659
*NONE*        45.211    30.343  0.53    78386      336        8    37210      0.15    28.82    5.651    9798.2      42.0    172
SMPRUNE      19.868    19.840  0.47    939227        0        0    80429      2.62      4.74    0.000      0.0      0.0    164
SMPINT        11.513    11.473  0.32      386        0    24088    48185      2.48      4.65    0.000      0.0      0.0    375
SMPOOR        5.703    4.270  0.45    90987      1250    6071    8497      2.89    24.97    0.000      14.9      0.2  1317
SMPIE          4.252    4.192  0.29      5171        28      95      145      0.11      0.41    0.044      54.4      0.2    341
SMPEER        3.503    1.381  0.31    10782        32      839    1746      1.83      3.42    0.004      12.8      0.0  1931
SMPART        1.624    1.518  0.69      2203        88      811      493    18.42    115.08    0.002      2.7      0.1    542
SMPILE        1.123    1.120  0.18        11        0        0    25003      2.57    27.12    0.000      0.0      0.0    106
SMPOLL        0.341    0.341  0.25        9        0        0  225146      2.82    17.42    0.000      0.0      0.0    134
SMPUNY        0.149    0.122  0.07      245        0        3      12      0.68      0.90    0.049      81.6      0.0    328
SMPEEL        0.049    0.010  0.36      158        0        0        8      0.04      0.03    0.000      0.0      0.0    340
SMPULL        0.013    0.003  0.00        4        0        0        6      0.01      0.00    0.000      0.0      0.0    289
SMPOP          0.010    0.008  0.00        1        0        0      16      0.00      0.01    0.000      0.0      0.0    122
SMPLOY        0.009    0.004  0.00        28        0        0      15      0.07      0.12    0.000      0.0      0.0    124
SMPROT        0.001    0.000  0.00        1        0        0        6      0.00      0.00    0.000      0.0      0.0    112
SIRMON        0.001    0.000  0.00        4        0        0        7      0.00      0.00    0.000      0.0      0.0    110
SMPOOCH        0.000    0.000  0.00        5        0        0        1      0.01      0.00    0.000      0.0      0.0    90
SMPYRE        0.000    0.000  0.00        1        0        0        5      0.00      0.00    0.000      0.0      0.0    99
SIRPRO        0.000    0.000  0.00        11        0        0        5      0.93      0.52    0.000      0.0      0.0    91
SIRSCAN        0.000    0.000  0.00        8        0        0        6      0.00      0.00    0.000      0.0      0.0    91
</p>


==<b id="utrep"></b>UTBLREPT==
==<b id="utrep"></b>UTBLREPT==
This report provides a guide to how large a server is actually needed to run a site's application subsystems.
This report provides a guide to how large a server is actually needed to run a site's application subsystems.
There is one set of lines produced for each subsystem that was active during the <var class="product">Model 204</var> run.
There is one set of lines produced for each subsystem that was active during the <var class="product">Model&nbsp;204</var> run.
There is a column for each server table that can be reset with a UTABLE command.
There is a column for each server table that can be reset with a <var>UTABLE</var> command.
The values are derived from since last statistics entries for CMPL, LOAD, or EVAL activities for each
The values are derived from since-last statistics entries for CMPL, LOAD, or EVAL activities for each procedure that is a member of the subsystem.
procedure that is a member of the subsystem.
The value reported is the highwater mark over all the entries.
The value reported is the highwater mark over all the entries.


<var class="product">SirAud</var> calculates one fixed server size using table sizes specified on
<var class="product">SirAud</var> calculates one fixed server size using table sizes specified on
the <var class="product">Model 204</var> user zero parameter line, the IODEV parameter lines, or
the <var class="product">Model&nbsp;204</var> user zero parameter line, the <var>[[IODEV parameter|IODEV]]</var> parameter lines, or the <var class="product">Model&nbsp;204</var> system default.
the <var class="product">Model 204</var> system default.
The largest value encountered is used in the calculation.
The largest value encountered is used in the calculation.
This is different from the way <var class="product">Model&nbsp;204</var> operates in
This is different from the way <var class="product">Model&nbsp;204</var> operates in that <var class="product">SirAud</var> uses one fixed server size for reporting purposes while
that <var class="product">SirAud</var> uses one fixed server size for reporting purposes while
<var class="product">Model&nbsp;204</var> calculates a fixed server size for each user.
<var class="product">Model 204</var> calculates a fixed server size for each user.
The variable server size is calculated for each subsystem using the aforementioned server table highwater marks from the since-last statistics entries.
The variable server size is calculated for each subsystem using the aforementioned server table highwater marks from the since last statistics entries.
 
<table class="thJustBold">
The <var class="product">SirAud</var> parameter <var>[[SirAud parameters#UTBLRANG parameter|UTBLRANG]]</var> is used to identify member procedures that possibly cause the subsystem to require a larger server.
<tr class="head"><th>Column</th><th>Content</th></tr>
For each server table, <var class="product">SirAud</var> calculates the mean highwater and standard deviation around the mean over all the member
procedures that were executed.
<var>UTBLRANG</var> specifies the number of standard deviations an individual procedure server table highwater mark can stray from the subsystem mean before it is flagged out of range. This is the <code>STANDARD DEVIATION FACTOR</code> value shown in the report.
 
Once all server tables of all member procedures have been
examined, <var class="product">SirAud</var> computes a new set of highwater marks and server size
using just those procedures whose server table highwater marks are in range.
These values are reported on the line identified by <code>*TARGET*</code>, below the <code>*CURRENT</code> line for the subsystem.
The "problem procedures" are then reported individually, sorted by the server size required to execute the procedure and its server table highwater marks.
 
<table>
<caption>UTBLERPT column headings</caption>
<tr class="head"><th>Column</th>
<th>Content</th></tr>


<tr><th>SERVER SIZE (K)</th>
<tr><td>SERVER SIZE (K)</td>
<td>The sum of the fixed and variable server sizes in units of 1024 bytes. This value shows approximately the largest server needed to execute all the subsystem's procedures that were executed during the <var class="product">Model 204</var> run.
<td>The right-most column in the report, this is the sum of the fixed and variable server sizes in units of 1024 bytes. This value shows approximately the largest server needed to execute all the subsystem's procedures that were executed during the <var class="product">Model&nbsp;204</var> run.
The subsystems are sorted in descending order by SERVER SIZE (K) for the line identified by <code>*CURRENT*</code>.
The subsystems are sorted in descending order by the <code>SERVER SIZE (K)</code> value for the line identified by <code>*CURRENT*</code>.
<p>
<p>
The columns other than SERVER SIZE (K) are the highwater marks of the corresponding server table as reported in the since last entries for the member procedures that were executed.
The columns other than <code>SERVER SIZE (K)</code> are the highwater marks of the corresponding server table as reported in the since-last entries for the member procedures that were executed.
These columns are: <b>LFTBL, LGTBL, LITBL, LNTBL, LQTBL, LSTBL, LTTBL, LVTBL, LXTBL, LFSCB</b>, and <b>LPDLST</b>.</p></td></tr>
These columns are: <code>LFTBL</code>, <code>LGTBL</code>, <code>LITBL</code>, <code>LNTBL</code>, <code>LQTBL</code>, <code>LSTBL</code>, <code>LTTBL</code>, <code>LVTBL</code>, <code>LXTBL</code>, <code>LFSCB</code>, and <code>LPDLST</code>.</p></td></tr>


<tr><th>SUBSYSTEM</th>
<tr><td>SUBSYSTEM</td>
<td>The name of the subsystem. The first line of the report presents the totals for all subsystems and uses
<td>The name of the subsystem. The first line of the report presents the totals for all subsystems and uses
<code>*TOTALS*</code> as the name. <code>*NONE*</code> is used for reporting on procedures that were run outside of subsystem context.</td></tr>
<code>*TOTALS*</code> as the name. <code>*NONE*</code> is used for reporting on procedures that were run outside of subsystem context.</td></tr>


<tr><th nowrap>PROCEDURE NAME</th>
<tr><td nowrap>PROCEDURE NAME</td>
<td>The name of the member procedure.</td></tr>
<td>The name of the member procedure.</td></tr>


<tr><th>PROC FILE</th>
<tr><td>PROC FILE</td>
<td>The name of the file to which the member procedure belongs.</td></tr>
<td>The name of the file to which the member procedure belongs.</td></tr>
</table>
</table>


The <var class="product">SirAud</var> parameter <code>UTBLRANG</code> is used to identify member
<b>Example</b>
procedures that possibly cause the subsystem to require a larger server.
 
For each server table, <var class="product">SirAud</var> calculates the mean highwater
An example follows:
and standard deviation around the mean over all the member
procedures that were executed.
UTBLRANG specifies the number of standard deviations an individual procedure server table highwater
mark can stray from the subsystem mean before it is flagged out of range.


Once all server tables of all member procedures have been
<p class="code" style="font-size: 85%;  padding: 1px">SIRAUD  1.05 - <b>UTBLREPT</b> -  OPTIMAL SUBSYSTEM UTABLES  FROM: Sample ONLINE  09/07/16 08:06:18-09/07/16 09:48:11  1
examined, <var class="product">SirAud</var> computes a new set of highwater marks and server size
SUBSYSTEM -  &#042;TOTALS*                                                                                STANDARD DEVIATION FACTOR -    2
using just those procedures whose server table highwater marks are in range.
                                    LFTBL  LGTBL  LITBL  LNTBL  LQTBL    LSTBL  LTTBL  LVTBL  LXTBL  LFSCB  LPDLST SERVER
These values are reported on the line identified by <code>*TARGET*</code>.
                                                                                                                              SIZE
The "problem procedures" are then reported individually, sorted by the server size required to execute the
                                                                                                                              (K)
procedure and its server table highwater marks.
            *CURRENT*              256748  309746      93  14561  56022  344806      17  34148      0  63883    7340  3161
SIRAUD  1.05 - UTBLREPT -  OPTIMAL SUBSYSTEM UTABLES  FROM: Q#O01US1 ONLINE  J0137518 CBRC 09/07/16 08:06:18-09/07/16 09:48:11  2
SUBSYSTEM - ISM1                                                                                    STANDARD DEVIATION FACTOR -    2
                                    LFTBL  LGTBL  LITBL  LNTBL  LQTBL    LSTBL  LTTBL  LVTBL  LXTBL  LFSCB  LPDLST SERVER
                                                                                                                              SIZE
                                                                                                                              (K)
            *CURRENT*              256748  309746      93  14537  55691  324584      17  34148      0  63883    7340  3136
            *TARGET*               53116  69659      56    7025  28992  161503      7  17297      0  15477    6148  1463
PROCEDURE                PROC                                    <b>PROBLEM PROCEDURES</b>
NAME                    FILE
PROCANYOLD42            MYPRFILE  16158  73466      50  14537  55691  241225      5  29888      0  16708    4980  2407
PROCANYOLD07            MYPRFILE  23698  40025      50  11019  45864  218732      4  34148      0    6756    5996  2290
PROCANYOLD19            MYPRFILE  13554  43772      50  10974  44124  228524      5  33337      0    6756    5996  2240
PROCANYOLD66            MYPRFILE  15538  59004      50  12411  38366  250229      5  31151      0    6756    6228  2137
PROCANYOLD23            MYPRFILE  131934  66488      50    9858  36773  223113      4  28160      0    6756    5164  2082
PROCANYOLD37            MYPRFILE  17854  54759      50  11479  41984  240498      4  26637      0    6756    6276  2030
PROCANYOLD01            MYPRFILE  60428  157919      50  10243  37263  194691      6  23458      0  63883    5852  1995
PROCANYOLD70            MYPRFILE    7414  55678      50  10292  40356  223453      5  24931      0    8192    6228  1913
PROCANYOLD12            MYPRFILE  24890  54644      50  11170  42921  199345      5  21570      0    6756    6204  1849
PROCANYOLD53            MYPRFILE  15072  39725      50    8145  34349  209040      17  25633      0    6756    5996  1792
PROCANYOLD91            MYPRFILE    8990  73965      50  11188  37507  177350      5  22673      0    6756    6228  1781
PROCANYOLD08            MYPRFILE  38358  52987      50    7584  30706  197914      5  25811      0    6756    5996  1759
PROCANYOLD18            MYPRFILE    9620  77467      50    9876  37327  190187      5  21257      0  14496    6228  1743
PROCANYOLD84            MYPRFILE  15184  69438      50    9549  33654  204767      3  22511      0    6756    4844  1724
</p>


==UTBLSUMM==
==UTBLSUMM==
This report presents the server table highwater
This report presents the server table highwater
marks that are used to produce the <code>*CURRENT*</code> lines of UTBLREPT.
marks that are used to produce the <code>*CURRENT*</code> lines of UTBLREPT.
<b>Example</b>
An example follows:
<p class="code" style="font-size: 85%;  padding: 1px">SirAud <b>UTBLSUMM</b> - Subsystem UTABLE summary Site: ROCKET Time: 10-06-16 15:17:30:11 - 10-06-16 16:06:38:45
  Subsystem  LFTBL  LGTBL  LITBL  LNTBL  LQTBL  LSTBL  LTTBL  LVTBL  LXTBL  LFSCB  LPDLST  Server
      *NONE*      0      0      0      0      0      0      0      0      0      0      0      0
      SIRMON      0  1781      0    504  2982 106928      4  1311      0      0    4516    164
      SIRPRO      0  1777      0  1247  13049 129528      4  7506      0  4607    5356    410
      SIRLIB      0    924      0  1247  13050 116907      4  7505      0      0    5356    392
    SIRSCAN      0  1122      0    669  4492 117352      0  2195      0  5200    4564    211
    SIRFILE    698    377      0    471  1771  8170      5    495      0  4304    1868      39
  SUBSYSMGMT      0      0      0      0      0      0      0      0      0      0      0      0
</p>


==See also==
==See also==

Latest revision as of 00:22, 14 October 2016

PERFREPT

Each line in a PERFREPT report corresponds to a partial interval as defined by the ACCTIM parameter. The columns in the report are derived from the information in the system partial statistics entries, since-last statistics entries for CMPL, LOAD, and EVAL activities, and user logout statistics entries. Unless otherwise noted, statistics values come from the system partial statistics entry.

PERFREPT column headings
ColumnContent
DATE The date when the statistics for the interval were logged to the journal.
END OF INTVL The time when the statistics for the interval were logged to the journal.
AVG USERS The connect time (CNCT) used by all logged in users during the interval, divided by the seconds in the interval. The connect time for a user is reported in the user partial and logout statistics entries.
%CPU The CPU value divided by the CNCT value.
PCPU The PCPU value reported for the interval when Model 204 is running on a single CPU.

When MP is active and offload subtask partial statistics are produced, the PCPU for the interval is the CPU for the interval divided by the PR for the interval.

SCREENS/SEC
DKRD/SEC
DKWR/SEC
DKWR-DKAW/SEC
SVRD+SVWR/SEC
LKWAIT+LKPOST/SEC
The statistics or sum of statistics, divided by the number of seconds in the interval.
JRNL I/O/SEC The number of blocks written during the interval, divided by the number of seconds in the interval.
RESP TIME SECS/SCRN MEAN The mean response time in seconds per screen over the interval.

Sample points for determining the mean are gathered from the user since-last statistics entries. Each execution of a procedure is accompanied by a CMPL/EVAL or LOAD/EVAL since-last pair.

The RQTM statistic reported in the since-last entries is summed for a user until an EVAL since-last entry is found that has a SCREENS value not equal 0. A sample point is then determined by taking the RQTM sum and dividing it by SCREENS. In the case when a partial interval completes and a sample point is in progress (no EVAL with SCREENS not equal 0 found yet), the sample point is determined using the RQTM sum through the last EVAL and dividing it by 1.

The RQTM from the last CMPL or LOAD since-last entry is attributed to the next partial interval.

RESP TIME SECS/SCRN STDEV The standard deviation of the response time in seconds per screen over the interval. Sample points for determining the standard deviation are the same as with the mean.
CPU SECS/SCRN MEAN The mean CPU time used in seconds per screen. Sample points for determining the mean are calculated the same way as for the mean response time, except that the CPU statistic is used instead of RQTM.
CPU SECS/SCRN STDEV The standard deviation of the CPU time used in seconds per screen over the interval. Sample points for determining the standard deviation are the same as with the mean.
SVRD+SVWR/SCRN Those statistics values divided by the SCREENS for the interval.

Example

An example follows:

SIRAUD 1.05 - PERFREPT - INTERVAL PERFORMANCE REPORT FROM: Sample ONLINE 09/07/16 08:06:18-09/07/16 09:48:11 1 DATE END AVG  % CPU STCPU PCPU SCREENS DKRD DKWR DKWR JRNL LKWAIT RESP TIME CPU SVRD OF USERS /CPU -DKAW I/O +LKPOST SECS/SCRN SECS/SCRN +SVWR INTVL /SEC /SEC /SEC /SEC /SEC /SEC MEAN STDEV MEAN STDEV /SCRN 09/07/16 08:06:32 0.0 0.0 0.00 589 0.00 0.14 0.07 0.07 0.00 0.0 0.000 0.000 0.000 0.000 0.00 09/07/16 08:15:00 0.4 11.2 0.41 925 0.00 165.30 2.08 2.08 2.85 0.0 2.105 8.400 1.024 5.752 0.00 09/07/16 08:30:00 1231.9 103.6 0.34 966 190.10 2021.13 349.21 322.74 48.16 6.4 0.084 3.796 0.004 0.078 0.22 09/07/16 08:45:00 5581.5 76.6 0.22 983 187.62 1528.29 302.55 279.81 39.61 1.7 0.125 6.661 0.003 0.099 0.21 09/07/16 09:00:00 6440.3 67.2 0.18 975 177.51 1411.38 298.18 279.45 39.79 0.8 0.203 6.377 0.002 0.024 0.20 09/07/16 09:15:00 6490.0 111.8 0.32 983 171.04 1411.90 304.08 281.03 39.82 2.4 0.243 7.044 0.005 0.046 0.21 09/07/16 09:30:00 6436.4 136.0 0.37 977 181.70 1521.28 315.99 288.76 42.59 2.9 0.172 7.310 0.006 0.056 0.21 09/07/16 09:45:00 6264.8 104.6 0.29 983 151.87 1224.76 306.48 290.33 42.62 1.5 0.192 7.706 0.004 0.039 0.23 09/07/16 09:48:11 14574.8 3.4 0.26 981 0.15 3.54 6.37 6.37 2.61 0.0 4.857 138.976 0.001 0.027 572.89

FILEREPT

This report is a subset of statistics from the file close statistics entries and other file information reported in the journal, totalled for each file and for all files. The Model 204 files are listed in descending order by the sum of the DKRD and DKWR columns.

FILEREPT column headings
Column Content
FILE NAME The name of the Model 204 file. The first line of the report presents the totals for all Model 204 files and uses *TOTALS* as the name.
DKRD
DKWR
DKUPDT
DIRRCD
BXFIND
BXNEXT
BXRFND
BADD+BDEL+BCHG
IXADD+IXDEL
RECADD+RECDEL
BXINSE+BXDELE+BXCHNG
RETRYC
The totals of the specified statistic or sum of statistics.

Note: DKUPDT is the number of times pages from the file were flushed out of the buffer pool.

Example

An example follows:

SIRAUD 1.05 - FILEREPT - SIGNIFICANT FILE REPORT FROM: Sample ONLINE 09/07/16 08:06:18-09/07/16 09:48:11 1 FILE DKRD DKWR DKUPDT DIRRCD BXFIND BXNEXT BXRFND BADD+BDEL IXADD RECADD BXINSE+ RETRYC NAME +BCHG +IXDEL +RECDEL BXDELE+BXCHNG *TOTALS* 8291409 1691152 157803 35514 59150986 269324351 2765067 7125855 233 76197 563660 0 ABCDECT0 221550 126562 0 0 222498 0 0 564399 0 27 194583 0 ABCDESY0 231992 102849 0 0 4070893 3167243 22733 1604339 0 4798 31470 0 ABCDESR0 189901 45136 0 0 383258 7089 7086 242045 0 150 267 0 ABCDEFF0 203121 8877 0 0 676491 74147 630 21041 0 453 1767 0 ABCDEM30 28541 180728 0 0 104283 40 0 221588 0 8020 30695 0 ABCDEM40 28110 180945 0 0 105010 36 0 223008 0 8076 32041 0 ABCDETM0 185174 23169 0 0 506850 0 0 88919 0 4 7447 0 ABCDEM20 28138 179854 0 0 104349 44 0 221552 0 8025 32045 0 ABCDERE0 159048 48564 0 0 2259576 0 0 108318 0 2 12148 0 ABCDEM10 28224 179352 0 0 103973 48 0 220841 0 7996 31845 0

PROCREPT

One logical line is produced for each unique combination of procedure name, procedure file name, and subsystem name executed during the Model 204 run, and a summation line is produced for all procedures executed. Each logical line requires two physical lines: the report is divided into two, stacked, listings.

The columns are derived from user since-last statistics entries for CMPL, LOAD, or EVAL activities. The procedures are sorted in descending order by TOTAL CPU SECS. The first output line below the column headings begins with *TOTALS* and presents the totals for all procedures executed.

PROCREPT column headings
Column Content
RANK The rank (integer) of the procedure by TOTAL CPU SECS.
PROCEDURE NAME The name of the procedure.
PROC FILE The name of the file to which the procedure belongs.
SUBSYSTEM NAME The name of the subsystem to which the procedure file belongs.
NUMBER OF RUNS The number of times a procedure was executed.
TOTAL CPU SECS The total CPU from the CMPL, LOAD, and EVAL since-last entries converted from milliseconds to seconds.
EVAL CPU SECS The total CPU from EVAL since-last entries converted from milliseconds to seconds.
STCPU/CPU The sum of all STCPU divided by the sum of all CPU.
RESP TIME MEAN The mean response time in seconds per procedure run. An execution of a procedure is accompanied by a CMPL/EVAL or LOAD/EVAL since-last pair, and it determines a sample point for calculating the mean response time.

SirAud assigns a variable known as RUNIN to each run. RUNIN is set to the SCREENS from the EVAL since-last entry, if SCREENS is not equal to 0. Otherwise, RUNIN is set to the IN from the EVAL since-last entry, if IN is not equal 0. Otherwise, RUNIN is set to 1.

The RQTM statistic from the CMPL or LOAD since-last entry is added to the RQTM from the EVAL. A sample point is then determined by taking the RQTM sum and dividing it by RUNIN.

RESP TIME STDEV The standard deviation of the response time in seconds per procedure run. Sample points for determining the standard deviation are the same as with the mean.
TOTAL DKRD+DKWR
TOTAL BXFIND
TOTAL BXNEXT
The totals of the specified statistic or sum of statistics.
UPDATE UNIT SECS MEAN The mean time in seconds an update unit was active for the procedure. A sample point is the time between the start and end of an update unit.
UPDATE UNIT SECS STDEV The standard deviation of the number of seconds seconds an update unit was active for the procedure. Sample points for determining the standard deviation are the same as with the mean.
NUMBER OF SCREENS The total SCREENS for the totals line. The sum of the RUNIN variable for a procedure is used for an individual procedure.
AVERAGE CPU SECS The total CPU divided by NUMBER OF SCREENS, then converted from milliseconds to seconds. All other "AVERAGE" columns are the total of the specified statistic divided by NUMBER OF SCREENS.
AVERAGE DKRD+DKWR
AVERAGE DKPR
AVERAGE SVRD+SVWR
AVERAGE STDEQ
AVERAGE FINDS
AVERAGE DIRRCD
AVERAGE RECDS
AVERAGE SORTS
AVERAGE STRECDS
The totals of the specified statistic or sum of statistics divided by NUMBER OF SCREENS.

Example

An example follows:

SIRAUD 1.05 - PROCREPT - SIGNIFICANT PROCEDURE REPORT FROM: Sample ONLINE 09/07/16 08:06:18-09/07/16 09:48:11 1 RANK PROCEDURE PROC SUBSYSTEM NUMBER TOTAL EVAL STCPU RESP RESP TOTAL TOTAL TOTAL NAME FILE NAME OF CPU CPU /CPU TIME TIME DKRD BXFIND BXNEXT RUNS SECS SECS MEAN STDEV +DKWR *TOTALS* 4601380 4641.543 4289.448 0.33 7.504 125.349 9591782 58915232 229796276 1 PROCANYOLD19 MYPRFILE SMPOW 7353 1427.525 1427.520 0.35 3.027 5.096 80412 131271 90888 2 PROCANYOLD06 MYPRFILE SMPAC 399987 130.461 130.051 0.25 2.528 4.627 10789 611591 0 3 PROCANYOLD02 MYPRFILE SMPAC 3020 120.147 119.935 0.29 2.735 4.748 68433 7398922 0 4 PROCANYOLD18 MYPRFILE SMPAIN 25657 111.540 111.492 0.24 2.612 4.780 36707 784129 0 5 PROCANYOLD11 MYPRFILE SMPOUR 1845 83.539 83.491 0.33 6.832 64.613 871863 3326283 29125 6 PROCANYOLD04 MYPRFILE SMPELT 204572 78.692 78.541 0.29 2.508 4.628 733 0 0 7 PROCANYOLD03 MYPRFILE SMPAIN 7642 76.744 76.053 0.37 2.621 4.628 66317 493667 0 8 PROCANYOLD15 MYPRFILE SMPAC 14091 76.301 76.004 0.28 2.658 4.729 169199 458538 0 9 PROCANYOLD10 MYPRFILE SMPAIN 7582 74.913 74.622 0.26 2.629 4.817 7545 322669 0 10 PROCANYOLD01 MYPRFILE SMPAC 196105 56.475 55.964 0.25 2.505 4.620 43634 2607794 0 RANK UPDATE UNIT SECS NUMBER AVERAGE AVERAGE AVERAGE AVERAGE AVERAGE AVERAGE AVERAGE AVERAGE AVERAGE AVERAGE MEAN STDEV OF CPU DKRD DKPR SVRD STDEQ FINDS DIRRCD RECDS SORTS STRECDS SCREENS SECS +DKWR +SVWR 0.000 0.000 879215 0.005 10.9 1228.6 0.1 9.77 20.9 0.0 2011.7 0.0 1.3 1 0.000 0.000 7353 0.194 10.9 10964.9 0.0 78.52 30.4 0.0 229990.1 0.0 0.0 2 0.000 0.000 203877 0.000 0.0 6.7 0.0 0.38 1.5 0.0 1.0 0.0 0.0 3 0.000 0.000 0 0.039 22.6 9937.2 0.0 16.32 342.4 0.0 394.5 0.0 0.0 4 0.000 0.000 0 0.004 1.4 2716.8 0.0 0.88 18.1 0.0 462.1 0.0 0.0 5 0.000 0.000 2536 0.032 343.7 16233.6 0.1 96.40 335.7 0.0 235.2 0.0 0.0 6 0.000 0.000 0 0.000 0.0 0.0 0.0 0.29 0.0 0.0 0.0 0.0 0.0 7 0.000 0.000 0 0.010 8.6 1731.7 0.0 11.97 21.2 3.3 39.6 0.0 0.0 8 0.000 0.000 0 0.005 12.0 2729.2 0.0 4.83 19.5 0.0 461.0 0.0 0.0 9 0.000 0.000 0 0.009 0.9 663.1 0.0 1.24 21.2 0.0 68.5 0.0 0.0 10 0.000 0.000 0 0.000 0.2 81.3 0.0 0.39 10.9 0.0 15.3 0.0 0.0

SUBREPT

There is one line produced for each subsystem that was active during the Model 204 run and a summation line for all subsystems that were active. The columns are derived from user since-last statistics entries for CMPL, LOAD, or EVAL activities for member procedures.

The subsystems are sorted in descending order by TOTAL CPU SECS. The first output line below the column headings begins with *TOTALS* and presents the totals for all active subsystems.

SUBREPT column headings
Column Content
SUBSYSTEM NAME The name of the subsystem. The first line of the report presents the totals for all subsystems and uses *TOTALS* as the name. *NONE* is used for reporting on procedures that were run outside of subsystem context.
TOTAL CPU SECS The total CPU from the CMPL, LOAD, and EVAL since-last entries converted from milliseconds to seconds.
EVAL CPU SECS The total CPU from EVAL since-last entries converted from milliseconds to seconds.
STCPU/CPU The sum of all STCPU divided by the sum of all CPU.
TOTAL DKRD+DKWR
TOTAL SVRD+SVWR
The total of the specified sums of statistics.
NUMBER OF SCREENS The total SCREENS from EVAL since-last entries.
NUMBER OF RUNS The number of times member procedures were executed.
RESP TIME MEAN The mean response time in seconds per member procedure run. An execution of a member procedure is accompanied by a CMPL/EVAL or LOAD/EVAL since-last pair, and it determines a sample point for calculating the mean response time.

SirAud assigns a variable known as RUNIN to each run. RUNIN is set to the SCREENS from the EVAL since-last entry, if SCREENS is not equal 0. Otherwise, RUNIN is set to the IN from the EVAL since-last entry, if IN is not equal 0. Otherwise, RUNIN is set to 1.

The RQTM statistic from the CMPL or LOAD since-last entry is added to the RQTM from the EVAL. A sample point is then determined by taking the RQTM sum and dividing it by RUNIN.

RESP TIME STDEV The standard deviation of the response time in seconds per member procedure run. Sample points for determining the standard deviation are the same as with the mean.
CPU SECS/SCRN CPU converted to seconds from milliseconds and divided by NUMBER OF SCREENS. All other "/SCRN" columns are the statistic value divided by NUMBER OF SCREENS.
DKRD+DKWR/SCRN
SVRD+SVWR/SCRN
Sums of statistics divided by NUMBER OF SCREENS.
SERVER SIZE (K) The smallest server size, in units of 1024 bytes, needed to execute the member procedures without any UTABLE commands. A server is made up of a fixed portion, determined by Model 204 user initialization parameters (for example, LOBUFF) that are fixed during the run, and a variable portion containing tables that can be resized using a UTABLE command.

The size calculated for this column is based on the member procedures that were actually executed during the run. See UTBLREPT for a more detailed explanation.

Example

An example follows:

SIRAUD 1.05 - SUBREPT - SIGNIFICANT SUBSYSTEM REPORT FROM: Sample ONLINE 09/07/16 08:06:18-09/07/16 09:48:11 1 SUBSYSTEM TOTAL EVAL STCPU TOTAL TOTAL NUMBER NUMBER RESP RESP CPU DKRD SVRD SERVER NAME CPU CPU /CPU DKRD SVRD OF OF TIME TIME SECS +DKWR +SVWR SIZE SECS SECS +DKWR +SVWR SCREENS RUNS MEAN STDEV /SCRN /SCRN /SCRN (K) *TOTALS* 4641.543 4289.448 0.33 9591782 127838 879215 4601380 7.50 125.34 0.005 10.9 0.1 3161 SMPOW 1601.074 1598.362 0.34 727849 0 182451 397647 2.47 4.63 0.008 3.9 0.0 1561 SMPAC 998.246 962.947 0.29 2041595 0 204063 1237058 2.54 4.65 0.004 10.0 0.0 2443 SMPOUR 886.205 791.923 0.38 4040404 88416 326239 526603 46.23 367.69 0.002 12.3 0.2 3136 SMPAIN 653.442 581.958 0.31 909909 2 0 947275 2.54 4.63 0.000 0.0 0.0 2994 SMPUTT 253.276 155.595 0.33 684889 37686 134098 224448 2.30 4.87 0.001 5.1 0.2 3076 SMPELT 107.607 107.432 0.33 1864 0 449 826040 2.48 4.61 0.239 4.1 0.0 498 SMPAN 48.323 16.606 0.37 57644 0 0 15368 0.19 0.73 0.000 0.0 0.0 2659 *NONE* 45.211 30.343 0.53 78386 336 8 37210 0.15 28.82 5.651 9798.2 42.0 172 SMPRUNE 19.868 19.840 0.47 939227 0 0 80429 2.62 4.74 0.000 0.0 0.0 164 SMPINT 11.513 11.473 0.32 386 0 24088 48185 2.48 4.65 0.000 0.0 0.0 375 SMPOOR 5.703 4.270 0.45 90987 1250 6071 8497 2.89 24.97 0.000 14.9 0.2 1317 SMPIE 4.252 4.192 0.29 5171 28 95 145 0.11 0.41 0.044 54.4 0.2 341 SMPEER 3.503 1.381 0.31 10782 32 839 1746 1.83 3.42 0.004 12.8 0.0 1931 SMPART 1.624 1.518 0.69 2203 88 811 493 18.42 115.08 0.002 2.7 0.1 542 SMPILE 1.123 1.120 0.18 11 0 0 25003 2.57 27.12 0.000 0.0 0.0 106 SMPOLL 0.341 0.341 0.25 9 0 0 225146 2.82 17.42 0.000 0.0 0.0 134 SMPUNY 0.149 0.122 0.07 245 0 3 12 0.68 0.90 0.049 81.6 0.0 328 SMPEEL 0.049 0.010 0.36 158 0 0 8 0.04 0.03 0.000 0.0 0.0 340 SMPULL 0.013 0.003 0.00 4 0 0 6 0.01 0.00 0.000 0.0 0.0 289 SMPOP 0.010 0.008 0.00 1 0 0 16 0.00 0.01 0.000 0.0 0.0 122 SMPLOY 0.009 0.004 0.00 28 0 0 15 0.07 0.12 0.000 0.0 0.0 124 SMPROT 0.001 0.000 0.00 1 0 0 6 0.00 0.00 0.000 0.0 0.0 112 SIRMON 0.001 0.000 0.00 4 0 0 7 0.00 0.00 0.000 0.0 0.0 110 SMPOOCH 0.000 0.000 0.00 5 0 0 1 0.01 0.00 0.000 0.0 0.0 90 SMPYRE 0.000 0.000 0.00 1 0 0 5 0.00 0.00 0.000 0.0 0.0 99 SIRPRO 0.000 0.000 0.00 11 0 0 5 0.93 0.52 0.000 0.0 0.0 91 SIRSCAN 0.000 0.000 0.00 8 0 0 6 0.00 0.00 0.000 0.0 0.0 91

UTBLREPT

This report provides a guide to how large a server is actually needed to run a site's application subsystems. There is one set of lines produced for each subsystem that was active during the Model 204 run. There is a column for each server table that can be reset with a UTABLE command. The values are derived from since-last statistics entries for CMPL, LOAD, or EVAL activities for each procedure that is a member of the subsystem. The value reported is the highwater mark over all the entries.

SirAud calculates one fixed server size using table sizes specified on the Model 204 user zero parameter line, the IODEV parameter lines, or the Model 204 system default. The largest value encountered is used in the calculation. This is different from the way Model 204 operates in that SirAud uses one fixed server size for reporting purposes while Model 204 calculates a fixed server size for each user. The variable server size is calculated for each subsystem using the aforementioned server table highwater marks from the since-last statistics entries.

The SirAud parameter UTBLRANG is used to identify member procedures that possibly cause the subsystem to require a larger server. For each server table, SirAud calculates the mean highwater and standard deviation around the mean over all the member procedures that were executed. UTBLRANG specifies the number of standard deviations an individual procedure server table highwater mark can stray from the subsystem mean before it is flagged out of range. This is the STANDARD DEVIATION FACTOR value shown in the report.

Once all server tables of all member procedures have been examined, SirAud computes a new set of highwater marks and server size using just those procedures whose server table highwater marks are in range. These values are reported on the line identified by *TARGET*, below the *CURRENT line for the subsystem. The "problem procedures" are then reported individually, sorted by the server size required to execute the procedure and its server table highwater marks.

UTBLERPT column headings
Column Content
SERVER SIZE (K) The right-most column in the report, this is the sum of the fixed and variable server sizes in units of 1024 bytes. This value shows approximately the largest server needed to execute all the subsystem's procedures that were executed during the Model 204 run.

The subsystems are sorted in descending order by the SERVER SIZE (K) value for the line identified by *CURRENT*.

The columns other than SERVER SIZE (K) are the highwater marks of the corresponding server table as reported in the since-last entries for the member procedures that were executed. These columns are: LFTBL, LGTBL, LITBL, LNTBL, LQTBL, LSTBL, LTTBL, LVTBL, LXTBL, LFSCB, and LPDLST.

SUBSYSTEM The name of the subsystem. The first line of the report presents the totals for all subsystems and uses *TOTALS* as the name. *NONE* is used for reporting on procedures that were run outside of subsystem context.
PROCEDURE NAME The name of the member procedure.
PROC FILE The name of the file to which the member procedure belongs.

Example

An example follows:

SIRAUD 1.05 - UTBLREPT - OPTIMAL SUBSYSTEM UTABLES FROM: Sample ONLINE 09/07/16 08:06:18-09/07/16 09:48:11 1 SUBSYSTEM - *TOTALS* STANDARD DEVIATION FACTOR - 2 LFTBL LGTBL LITBL LNTBL LQTBL LSTBL LTTBL LVTBL LXTBL LFSCB LPDLST SERVER SIZE (K) *CURRENT* 256748 309746 93 14561 56022 344806 17 34148 0 63883 7340 3161 SIRAUD 1.05 - UTBLREPT - OPTIMAL SUBSYSTEM UTABLES FROM: Q#O01US1 ONLINE J0137518 CBRC 09/07/16 08:06:18-09/07/16 09:48:11 2 SUBSYSTEM - ISM1 STANDARD DEVIATION FACTOR - 2 LFTBL LGTBL LITBL LNTBL LQTBL LSTBL LTTBL LVTBL LXTBL LFSCB LPDLST SERVER SIZE (K) *CURRENT* 256748 309746 93 14537 55691 324584 17 34148 0 63883 7340 3136 *TARGET* 53116 69659 56 7025 28992 161503 7 17297 0 15477 6148 1463 PROCEDURE PROC PROBLEM PROCEDURES NAME FILE PROCANYOLD42 MYPRFILE 16158 73466 50 14537 55691 241225 5 29888 0 16708 4980 2407 PROCANYOLD07 MYPRFILE 23698 40025 50 11019 45864 218732 4 34148 0 6756 5996 2290 PROCANYOLD19 MYPRFILE 13554 43772 50 10974 44124 228524 5 33337 0 6756 5996 2240 PROCANYOLD66 MYPRFILE 15538 59004 50 12411 38366 250229 5 31151 0 6756 6228 2137 PROCANYOLD23 MYPRFILE 131934 66488 50 9858 36773 223113 4 28160 0 6756 5164 2082 PROCANYOLD37 MYPRFILE 17854 54759 50 11479 41984 240498 4 26637 0 6756 6276 2030 PROCANYOLD01 MYPRFILE 60428 157919 50 10243 37263 194691 6 23458 0 63883 5852 1995 PROCANYOLD70 MYPRFILE 7414 55678 50 10292 40356 223453 5 24931 0 8192 6228 1913 PROCANYOLD12 MYPRFILE 24890 54644 50 11170 42921 199345 5 21570 0 6756 6204 1849 PROCANYOLD53 MYPRFILE 15072 39725 50 8145 34349 209040 17 25633 0 6756 5996 1792 PROCANYOLD91 MYPRFILE 8990 73965 50 11188 37507 177350 5 22673 0 6756 6228 1781 PROCANYOLD08 MYPRFILE 38358 52987 50 7584 30706 197914 5 25811 0 6756 5996 1759 PROCANYOLD18 MYPRFILE 9620 77467 50 9876 37327 190187 5 21257 0 14496 6228 1743 PROCANYOLD84 MYPRFILE 15184 69438 50 9549 33654 204767 3 22511 0 6756 4844 1724

UTBLSUMM

This report presents the server table highwater marks that are used to produce the *CURRENT* lines of UTBLREPT.

Example

An example follows:

SirAud UTBLSUMM - Subsystem UTABLE summary Site: ROCKET Time: 10-06-16 15:17:30:11 - 10-06-16 16:06:38:45 Subsystem LFTBL LGTBL LITBL LNTBL LQTBL LSTBL LTTBL LVTBL LXTBL LFSCB LPDLST Server *NONE* 0 0 0 0 0 0 0 0 0 0 0 0 SIRMON 0 1781 0 504 2982 106928 4 1311 0 0 4516 164 SIRPRO 0 1777 0 1247 13049 129528 4 7506 0 4607 5356 410 SIRLIB 0 924 0 1247 13050 116907 4 7505 0 0 5356 392 SIRSCAN 0 1122 0 669 4492 117352 0 2195 0 5200 4564 211 SIRFILE 698 377 0 471 1771 8170 5 495 0 4304 1868 39 SUBSYSMGMT 0 0 0 0 0 0 0 0 0 0 0 0

See also