SirAud report contents: Difference between revisions
Jump to navigation
Jump to search
m (1 revision: SirAud pages) |
m (misc formatting) |
||
| Line 1: | Line 1: | ||
== | ==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 | <table> | ||
<tr class="head"><th>Column</th><th>Content</th></tr> | <tr class="head"><th>Column</th><th>Content</th></tr> | ||
<tr>< | <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>< | <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>< | <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>< | <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>< | <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>< | <tr><td>SCREENS/SEC <br>DKRD+DKWR/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>< | <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>< | <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> | |||
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> | |||
<p> | <p> | ||
The RQTM from the last CMPL or LOAD since-last entry is attributed to the next partial interval.</p></td></tr> | |||
The RQTM from the last CMPL or LOAD since last entry is attributed to the next partial interval.</p></td></tr> | |||
<tr>< | <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>< | <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>< | <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>< | <tr><td>DKRD+DKWR/SCRN <br>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> | ||
| Line 61: | Line 58: | ||
totalled for each file and for all files. | totalled for each file and for all files. | ||
The <var class="product">Model 204</var> files are listed in descending order by the sum of the DKRD and DKWR columns. | The <var class="product">Model 204</var> files are listed in descending order by the sum of the DKRD and DKWR columns. | ||
<table | <table> | ||
<tr class="head"><th>Column</th><th>Content</th></tr> | <tr class="head"><th>Column</th> | ||
<th>Content</th></tr> | |||
<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 204</var> files and uses *TOTALS* as the name.</td></tr> | <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 <code>*TOTALS*</code> as the name.</td></tr> | ||
<tr>< | <tr><td>DKRD <br>DKWR <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.</td></tr> | <td>The totals of the specified statistic or sum of statistics.</td></tr> | ||
<tr>< | <tr><td>DKUPDT</td> | ||
<td>The number of times pages from the file were flushed out of the buffer pool.</td></tr> | <td>The number of times pages from the file were flushed out of the buffer pool.</td></tr> | ||
</table> | </table> | ||
| Line 80: | Line 78: | ||
Each logical line requires two physical lines. | 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 | The procedures are sorted in descending order by <code>TOTAL CPU SECS</code>. | ||
<table | <table> | ||
<tr class="head"><th>Column</th><th>Content</th></tr> | <tr class="head"><th>Column</th> | ||
<th>Content</th></tr> | |||
<tr>< | <tr><td>RANK</td> | ||
<td>The rank of the procedure by TOTAL CPU | <td>The rank of the procedure by <code>TOTAL CPU SECS</code>.</td></tr> | ||
<tr>< | <tr><td>PROCEDURE NAME</td> | ||
<td>The name of the procedure.</td></tr> | <td>The name of the procedure.</td></tr> | ||
<tr>< | <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>< | <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>< | <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>< | <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>< | <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>< | <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>< | <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>< | <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>< | <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>< | <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>< | <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>< | <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>< | <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>< | <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> | ||
| Line 144: | Line 143: | ||
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 204</var> run and a summation line for all subsystems that were active. | was active during the <var class="product">Model 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 | The subsystems are sorted in descending order by <code>TOTAL CPU SECS</code>. | ||
<table | <table> | ||
<tr class="head"><th>Column</th><th>Content</th></tr> | <tr class="head"><th>Column</th> | ||
<th>Content</th></tr> | |||
<tr>< | <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>< | <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>< | <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>< | <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>< | <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 statistics sums.</td></tr> | ||
<tr>< | <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>< | <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>< | <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>< | <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>< | <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 SCREENS. All other "/SCRN" columns are the statistic value divided by SCREENS.</td></tr> | ||
<tr>< | <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 the SCREENS.</td></tr> | ||
<tr>< | <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 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 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 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 204</var> user zero parameter line, the <var>[[IODEV parameter|IODEV]]</var> parameter lines, or the <var class="product">Model 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 204</var> operates in | This is different from the way <var class="product">Model 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 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 | |||
<tr class="head"><th>Column</th><th>Content</th></tr> | <table> | ||
<tr class="head"><th>Column</th> | |||
<th>Content</th></tr> | |||
<tr>< | <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 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. | ||
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 <code>SERVER SIZE (K)</code> 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: < | 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>< | <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>< | <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>< | <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 < | 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. | ||
procedures that possibly cause the subsystem to require a larger server. | |||
For each server table, <var class="product">SirAud</var> calculates the mean highwater | For each server table, <var class="product">SirAud</var> calculates the mean highwater | ||
and standard deviation around the mean over all the member | and standard deviation around the mean over all the member | ||
procedures that were executed. | procedures that were executed. | ||
UTBLRANG specifies the number of standard deviations an individual procedure server table highwater | <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. | mark can stray from the subsystem mean before it is flagged out of range. | ||
| Line 241: | Line 241: | ||
using just those procedures whose server table highwater marks are in range. | using just those procedures whose server table highwater marks are in range. | ||
These values are reported on the line identified by <code>*TARGET*</code>. | These values are reported on the line identified by <code>*TARGET*</code>. | ||
The "problem procedures" are then reported individually, sorted by the server size required to execute the | The "problem procedures" are then reported individually, sorted by the server size required to execute the procedure and its server table highwater marks. | ||
procedure and its server table highwater marks. | |||
==UTBLSUMM== | ==UTBLSUMM== | ||
Revision as of 23:15, 12 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.
| Column | Content |
|---|---|
| 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+DKWR/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. |
| DKRD+DKWR/SCRN SVRD+SVWR/SCRN |
Those statistics values divided by the SCREENS for the interval. |
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.
| 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 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. |
| DKUPDT | The number of times pages from the file were flushed out of the buffer pool. |
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 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.
| Column | Content |
|---|---|
| RANK | The rank 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
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 |
| 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. |
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.
| 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 statistics sums. |
| 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
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 |
| 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 SCREENS. All other "/SCRN" columns are the statistic value divided by SCREENS. |
| DKRD+DKWR/SCRN SVRD+SVWR/SCRN |
Sums of statistics divided by the 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. |
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.
| Column | Content |
|---|---|
| SERVER SIZE (K) | 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 columns other than |
| 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. |
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.
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*.
The "problem procedures" are then reported individually, sorted by the server size required to execute the procedure and its server table highwater marks.
UTBLSUMM
This report presents the server table highwater
marks that are used to produce the *CURRENT* lines of UTBLREPT.