RESTHRSH parameter: Difference between revisions
Jump to navigation
Jump to search
m (minor formatting) |
|||
| (One intermediate revision by one other user not shown) | |||
| Line 16: | Line 16: | ||
==Description== | ==Description== | ||
<p> | <p> | ||
<var>RESTHRSH</var> specifies the point at which a request's QTBL and NTBL are saved in [[ | <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> | <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> | <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> | ||
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.