SirAud report contents: Difference between revisions
m (misc formatting) |
m (add examples) |
||
Line 6: | Line 6: | ||
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> | ||
<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> | ||
Line 25: | Line 26: | ||
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> | 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><td>SCREENS/SEC <br>DKRD | <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> | ||
Line 49: | Line 50: | ||
<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><td | <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 59: | Line 78: | ||
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> | ||
<caption>FILEREPT column headings</caption> | |||
<tr class="head"><th>Column</th> | <tr class="head"><th>Column</th> | ||
<th>Content</th></tr> | <th>Content</th></tr> | ||
<tr><td>FILE NAME</td> | <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 <code>*TOTALS*</code> 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><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> | <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.</td></tr> | <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> | |||
<b>Example</b> | |||
An example follows: | |||
< | <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 | ||
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 | |||
</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 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 SECS</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> | <table> | ||
<caption>PROCREPT column headings</caption> | |||
<tr class="head"><th>Column</th> | <tr class="head"><th>Column</th> | ||
<th>Content</th></tr> | <th>Content</th></tr> | ||
<tr><td>RANK</td> | <tr><td>RANK</td> | ||
<td>The rank of the procedure by <code>TOTAL CPU SECS</code>.</td></tr> | <td>The rank (integer) of the procedure by <code>TOTAL CPU SECS</code>.</td></tr> | ||
<tr><td>PROCEDURE NAME</td> | <tr><td>PROCEDURE NAME</td> | ||
Line 139: | Line 178: | ||
<td>The totals of the specified statistic or sum of statistics divided by <code>NUMBER OF SCREENS</code>.</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== | ||
Line 144: | Line 219: | ||
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 <code>TOTAL CPU SECS</code>. | |||
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. | |||
<table> | <table> | ||
<caption>SUBREPT column headings</caption> | |||
<tr class="head"><th>Column</th> | <tr class="head"><th>Column</th> | ||
<th>Content</th></tr> | <th>Content</th></tr> | ||
Line 162: | Line 239: | ||
<tr><td>TOTAL DKRD+DKWR <br>TOTAL SVRD+SVWR</td> | <tr><td>TOTAL DKRD+DKWR <br>TOTAL SVRD+SVWR</td> | ||
<td>The total of the specified statistics | <td>The total of the specified sums of statistics.</td></tr> | ||
<tr><td nowrap>NUMBER OF SCREENS</td> | <tr><td nowrap>NUMBER OF SCREENS</td> | ||
Line 182: | Line 259: | ||
<tr><td>CPU SECS/SCRN</td> | <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><td>DKRD+DKWR/SCRN <br>SVRD+SVWR/SCRN</td> | <tr><td>DKRD+DKWR/SCRN <br>SVRD+SVWR/SCRN</td> | ||
<td>Sums of statistics divided by | <td>Sums of statistics divided by <code>NUMBER OF SCREENS</code>.</td></tr> | ||
<tr><td>SERVER SIZE (K)</td> | <tr><td>SERVER SIZE (K)</td> | ||
Line 192: | Line 269: | ||
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> | 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== | ||
Line 203: | Line 318: | ||
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> user zero parameter line, the <var>[[IODEV parameter|IODEV]]</var> parameter lines, or 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. | ||
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. | |||
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> | <table> | ||
<caption>UTBLERPT column headings</caption> | |||
<tr class="head"><th>Column</th> | <tr class="head"><th>Column</th> | ||
<th>Content</th></tr> | <th>Content</th></tr> | ||
<tr><td>SERVER SIZE (K)</td> | <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 204</var> run. | ||
The subsystems are sorted in descending order by <code>SERVER SIZE (K)</code> 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 <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. | 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. | ||
Line 230: | Line 356: | ||
</table> | </table> | ||
<b>Example</b> | |||
An example follows: | |||
<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 | |||
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 <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.
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/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.
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.
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
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 . |
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.
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
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 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.
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
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. |
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