LPDLST parameter: Difference between revisions

From m204wiki
Jump to navigation Jump to search
 
(8 intermediate revisions by 3 users not shown)
Line 3: Line 3:
<dl>
<dl>
<dt>Default value
<dt>Default value
<dd>5000
<dd>&nbsp;&nbsp;5000 (version 7.4 and earlier)
<dd>10000 (version 7.5 and later)
<dt>Parameter type
<dt>Parameter type
<dd>Utable
<dd>Utable
<dt>Where set
<dt>Where set
<dd>On user's parameter line or reset by UTABLE command
<dd>On user's parameter line or reset by <var>[[UTABLE_command|UTABLE]]</var> command
<dt>Related products
<dt>Related products
<dd>All
<dd>All
<dt>Introduced
<dt>Introduced
<dd><var class="product">Model 204 V6.1</var> or earlier
<dd><var class="product">Model 204 V2.2</var> or earlier
</dl>
</dl>
==Description==
==Description==
<p>The length of the user pushdown list, a work area used for <var class="product">Model&nbsp;204</var> program flow control</p>
<p>The length of the user pushdown list, a work area used for <var class="product">Model&nbsp;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:
<ul>
<li>
5000 to 32760 (version 7.4 and earlier)</li>
<li>10000 to 65536 (version 7.5 and later)</li>
</ul>
LPDLST is set to the minimum value by default.
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 might need to increase LPDLST in the following cases:
You might need to increase LPDLST in the following cases:
<ul>
<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>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>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 <var>[[LQTBL_parameter|LQTBL]]</var> parameter.</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><var>[[Checkpoints:_Storing_before-images_of_changed_pages|Checkpointing]]</var> (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>Allowing for SEQPDL.</b> The <var>[[SEQPDL parameter|SEQPDL]]</var> parameter, by default, adds 3072 bytes to the free space set aside in the user pushdown list. If your applications currently use most of the area that you specified with LPDLST, to avoid an ERROR 2126 USER'S PUSHDOWN LIST OVERFLOWED you might need to increase LPDLST by up to 3072 bytes, or more if you reset SEQPDL to a larger value.
<li><b>Allowing for SEQPDL.</b> The <var>[[SEQPDL parameter|SEQPDL]]</var> parameter, by default, adds an additional 3072 bytes to the free space set aside in the user pushdown list. If your applications currently use most of the area that you specified with LPDLST, to avoid an <var>[[New_and_updated_messages_in_Model_204_version_7.5#M204.2126:_User.27s_pushdown_list_overflowed|ERROR 2126 USER'S PUSHDOWN LIST OVERFLOWED]]</var> you might need to increase LPDLST by up to 3072 bytes, or more if you reset SEQPDL to a larger value.
</li>  
</li>  
</ul>
</ul>

Latest revision as of 15:56, 5 August 2015

Length of user push down list

Summary

Default value
  5000 (version 7.4 and earlier)
10000 (version 7.5 and later)
Parameter type
Utable
Where set
On user's parameter line or reset by UTABLE command
Related products
All
Introduced
Model 204 V2.2 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 32760 (version 7.4 and earlier)
  • 10000 to 65536 (version 7.5 and later)

LPDLST is set to the minimum value by default.

Its recommended initial value for SQL processing is the maximum.

You can monitor LPDLST use with the PDL audit trail statistic.

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 parameter.
  • Checkpointing (31-bit O/S). Because checkpointing is asynchronous in 31-bit operating systems, you might need to increase LPDLST in such environments.
  • Allowing for SEQPDL. The SEQPDL parameter, by default, adds an additional 3072 bytes to the free space set aside in the user pushdown list. If your applications currently use most of the area that you specified with LPDLST, to avoid an ERROR 2126 USER'S PUSHDOWN LIST OVERFLOWED you might need to increase LPDLST by up to 3072 bytes, or more if you reset SEQPDL to a larger value.