LPDLST parameter: Difference between revisions
Jump to navigation
Jump to search
| Line 15: | Line 15: | ||
==Description== | ==Description== | ||
<p>The length of the user pushdown list, a work area used for <var class="product">Model 204</var> program flow control</p> | <p>The length of the user pushdown list, a work area used for <var class="product">Model 204</var> program flow control</p> | ||
<p>LPDLST can range from 5000 to as large as 32760. Its recommended initial value for SQL processing is the maximum.</p> | <p>LPDLST can range from 5000 to as large as 32760. Its recommended initial value for SQL processing is the maximum.</p> | ||
<p>You can monitor LPDLST use with the PDL audit trail statistic.</p> | <p>You can monitor LPDLST use with the PDL audit trail statistic.</p> | ||
< | You can increase LPDLST using UTABLE LPDLST You might need to increase LPDLST in the following cases: | ||
< | <ul> | ||
< | <li><b>Complex C patterns.</b> LPDLST also includes some space for the C pattern matcher processing. Complex patterns (for example, patterns involving nested repeated patterns or nested wildcards) might overflow the LPDLST area and require you to increase the LPDLST setting to 32K.</li> | ||
<li><b>Unrecoverable errors when running User Language requests.</b> You might need to increase the size of LPDLST (by approximately 10-20%, depending on your environment and the applications being run) and/or the LQTBL and LSERVPD parameters.</li> | |||
<li><b>Checkpointing (31-bit O/S).</b> Because checkpointing is asynchronous in 31-bit operating systems, you might need to increase LPDLST in such environments.</li> | |||
<li><b>Large SEQPDL value.</b> The <var>[[SEQPDL parameter|SEQPDL]]</var> parameter adds 3072 bytes to the free space set aside in the user pushdown list. If your applications actually use most of the user pushdown list size that you specified with LPDLST, you might need to increase LPDLST (using UTABLE LPDLST) by up to 3072 bytes, or more if you specify a value for SEQPDL that is larger than the 4096 default value. | |||
</li> | |||
</ul> | |||
[[Category:Utable parameters]] | [[Category:Utable parameters]] | ||
[[Category:Parameters]] | [[Category:Parameters]] | ||
Revision as of 00:40, 4 September 2013
Length of user push down list
Summary
- Default value
- 5000
- Parameter type
- Utable
- Where set
- On user's parameter line or reset by UTABLE command
- Related products
- All
- Introduced
- Model 204 V6.1 or earlier
Description
The length of the user pushdown list, a work area used for Model 204 program flow control
LPDLST can range from 5000 to as large as 32760. Its recommended initial value for SQL processing is the maximum.
You can monitor LPDLST use with the PDL audit trail statistic.
You can increase LPDLST using UTABLE LPDLST You might need to increase LPDLST in the following cases:
- Complex C patterns. LPDLST also includes some space for the C pattern matcher processing. Complex patterns (for example, patterns involving nested repeated patterns or nested wildcards) might overflow the LPDLST area and require you to increase the LPDLST setting to 32K.
- Unrecoverable errors when running User Language requests. You might need to increase the size of LPDLST (by approximately 10-20%, depending on your environment and the applications being run) and/or the LQTBL and LSERVPD parameters.
- Checkpointing (31-bit O/S). Because checkpointing is asynchronous in 31-bit operating systems, you might need to increase LPDLST in such environments.
- Large SEQPDL value. The SEQPDL parameter adds 3072 bytes to the free space set aside in the user pushdown list. If your applications actually use most of the user pushdown list size that you specified with LPDLST, you might need to increase LPDLST (using UTABLE LPDLST) by up to 3072 bytes, or more if you specify a value for SEQPDL that is larger than the 4096 default value.