RESTHRSH parameter: Difference between revisions
Jump to navigation
Jump to search
(Automatically generated page update) |
m (minor formatting) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 11: | Line 11: | ||
<dd>All | <dd>All | ||
<dt>Introduced | <dt>Introduced | ||
<dd><var class="product">Model 204 | <dd><var class="product">Model 204 V2.2</var> | ||
</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]] | ||
Latest revision as of 16:37, 23 May 2017
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 V2.2
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.