SEQOPT parameter: Difference between revisions
Jump to navigation
Jump to search
m (→Description: mention NUMBUFG) |
m (→Description: remove MAXBUF formula -- let user link to MAXBUF page) |
||
| Line 24: | Line 24: | ||
The prefetch feature can also be controlled with the <var>RESET</var> command issued by a user having system manager privileges.</p> | The prefetch feature can also be controlled with the <var>RESET</var> command issued by a user having system manager privileges.</p> | ||
<p> | <p> | ||
Use of the prefetch feature requires that the <var>[[NUMBUFG parameter|NUMBUFG]]</var> or the <var>[[MAXBUF parameter|MAXBUF]]</var> parameter be set large enough to accommodate the look-ahead reads. Without this setting, performance might worsen. | Use of the prefetch feature requires that the <var>[[NUMBUFG parameter|NUMBUFG]]</var> or the <var>[[MAXBUF parameter|MAXBUF]]</var> parameter be set large enough to accommodate the look-ahead reads. Without this setting, performance might worsen. | ||
</p> | </p> | ||
[[Category:System parameters]] | [[Category:System parameters]] | ||
[[Category:Parameters]] | [[Category:Parameters]] | ||
Revision as of 23:21, 25 August 2016
Sequential processing options
Summary
- Default value
- 0
- Parameter type
- System
- Where set
- On User 0's parameter line
- Related products
- All
- Introduced
- Model 204 V6.1 or earlier
Description
Enables or disables the prefetch (look-ahead read) feature.
SEQOPT must be either zero or 1. If the default value of zero is used, the prefetch feature is disabled. If a value of 1 is specified, the prefetch feature is enabled.
The prefetch feature can produce performance improvements for applications containing FOR EACH RECORD statements. The prefetch feature is also described in Prefetch feature.
The prefetch feature can also be controlled with the RESET command issued by a user having system manager privileges.
Use of the prefetch feature requires that the NUMBUFG or the MAXBUF parameter be set large enough to accommodate the look-ahead reads. Without this setting, performance might worsen.