RESTHRSH parameter: Difference between revisions
Jump to navigation
Jump to search
(Automatically generated page update) |
m (misc formatting) |
||
| Line 13: | Line 13: | ||
<dd><var class="product">Model 204 V6.1</var> or earlier | <dd><var class="product">Model 204 V6.1</var> or earlier | ||
</dl> | </dl> | ||
==Description== | ==Description== | ||
<p> | <p> | ||
<p>RESTHRSH | <var>RESTHRSH</var> specifies the point at which a request's QTBL and NTBL are saved in [[Performance_monitoring_and_tuning#Resident Request feature for precompiled procedures|resident storage]].</p> | ||
<p>If NUSERS=NSERVS (that is, no server swapping), RESTHRSH is the number of times the request has been run.</p> | <p> | ||
<var>RESTHRSH</var> lets you specify the number of server writes that a request executes before <var class="product">Model 204</var> saves its QTBL and NTBL in resident storage (provided that there is enough storage). The amount of storage available for saving resident requests is determined by the <var>[[RESSIZE parameter|RESSIZE]]</var> or the <var>[[RESPAGE parameter|RESPAGE]]</var> parameter.</p> | |||
<p> | |||
If <code>NUSERS=NSERVS</code> (that is, no server swapping), <var>RESTHRSH</var> is the number of times the request has been run.</p> | |||
[[Category:System parameters]] | [[Category:System parameters]] | ||
[[Category:Parameters]] | [[Category:Parameters]] | ||
Revision as of 20:39, 9 June 2016
Server write threshold for making request resident
Summary
- Default value
- 100
- Parameter type
- System
- Where set
- On User 0's parameter line or reset by system manager
- Related products
- All
- Introduced
- Model 204 V6.1 or earlier
Description
RESTHRSH specifies the point at which a request's QTBL and NTBL are saved in resident storage.
RESTHRSH lets you specify the number of server writes that a request executes before Model 204 saves its QTBL and NTBL in resident storage (provided that there is enough storage). The amount of storage available for saving resident requests is determined by the RESSIZE or the RESPAGE parameter.
If NUSERS=NSERVS (that is, no server swapping), RESTHRSH is the number of times the request has been run.