LHEAP parameter - Revision history

JAL at 23:49, 2 December 2014

2014-12-02T23:49:46Z

← Older revision		Revision as of 23:49, 2 December 2014
Line 15:		Line 15:

	==Description==		==Description==
	<p>~~The~~ size of the HEAP storage area </p>		<p>
	<p>HEAP is a dynamic storage area included in the variable portion of the server area and required for the processing of SQL C routines. The size of HEAP is specified with the LHEAP parameter and is added to the variable size calculation of the server area. </p>		<var>LHEAP</var> specifies the size of the HEAP storage area. </p>
	<p>The initial value for SQL threads varies, based on your application requirements. Specify the initial value on the first <var>[[IODEV_parameter\|IODEV]]</var> line for IODEV=19. Do not specify it with the User 0 parameters, because this wastes space. For non-SQL threads, which do not require HEAP space, LHEAP can default to zero. </p>		<p>
	<p>The LHEAP maximum is 2 million.</p>		HEAP is a dynamic storage area included in the variable portion of the server area and required for the processing of SQL C routines. The size of HEAP is specified with the <var>LHEAP</var> parameter, and it is added to the variable size calculation of the server area. </p>
			<p>
			The initial value for SQL threads varies, based on your application requirements. Specify the initial value on the first <var>[[IODEV_parameter\|IODEV]]</var> line for IODEV=19. Do not specify it with the User 0 parameters, because this wastes space. For non-SQL threads, which do not require HEAP space, <var>LHEAP</var> can default to zero. </p>
			<p>
			The <var>LHEAP</var> maximum is 2 million.</p>

	====Handling SQL statements greater than 32k bytes====		====Handling SQL statements greater than 32k bytes====
	<p>When handling an SQL statement that is greater than 32K bytes, you must consider the LHEAP parameter. If its value is not large enough, the error message invoked includes the name of the relevant parameter. Setting LHEAP=200000 is recommended for handling larger SQL statements.</p>		<p>
			When handling an SQL statement that is greater than 32K bytes, you must consider the <var>LHEAP</var> parameter. If its value is not large enough, the error message invoked includes the name of the relevant parameter. Setting <code>LHEAP=200000</code> is recommended for handling larger SQL statements.</p>

	[[Category:Utable parameters]]		[[Category:Utable parameters]]
	[[Category:Parameters]]		[[Category:Parameters]]

DCameron: /* Handling SQL statements greater than 32k bytes */

2014-12-02T14:54:56Z

Handling SQL statements greater than 32k bytes

← Older revision		Revision as of 14:54, 2 December 2014
Line 20:		Line 20:
	<p>The LHEAP maximum is 2 million.</p>		<p>The LHEAP maximum is 2 million.</p>
	====Handling SQL statements greater than 32k bytes====		====Handling SQL statements greater than 32k bytes====
	<p>When handling an SQL statement that is greater than 32K, you must consider the LHEAP parameter. If its value is not large enough, the error message invoked includes the name of the relevant parameter. ~~Rocket Software recommends setting~~ LHEAP=200000 ~~to handle~~ SQL statements.</p>		<p>When handling an SQL statement that is greater than 32K bytes, you must consider the LHEAP parameter. If its value is not large enough, the error message invoked includes the name of the relevant parameter. Setting LHEAP=200000 is recommended for handling larger SQL statements.</p>
	[[Category:Utable parameters]]		[[Category:Utable parameters]]
	[[Category:Parameters]]		[[Category:Parameters]]

DCameron: /* Description */

2014-12-02T14:52:27Z

Description

← Older revision		Revision as of 14:52, 2 December 2014
Line 17:		Line 17:
	<p>The size of the HEAP storage area </p>		<p>The size of the HEAP storage area </p>
	<p>HEAP is a dynamic storage area included in the variable portion of the server area and required for the processing of SQL C routines. The size of HEAP is specified with the LHEAP parameter and is added to the variable size calculation of the server area. </p>		<p>HEAP is a dynamic storage area included in the variable portion of the server area and required for the processing of SQL C routines. The size of HEAP is specified with the LHEAP parameter and is added to the variable size calculation of the server area. </p>
	<p>The initial value for SQL threads varies, based on your application requirements. Specify the initial value on the first IODEV line for IODEV=19. Do not specify it with the User 0 parameters, because this wastes space. For non-SQL threads, which do not require HEAP space, LHEAP can default to zero. </p>		<p>The initial value for SQL threads varies, based on your application requirements. Specify the initial value on the first <var>[[IODEV_parameter\|IODEV]]</var> line for IODEV=19. Do not specify it with the User 0 parameters, because this wastes space. For non-SQL threads, which do not require HEAP space, LHEAP can default to zero. </p>
	<p>The LHEAP maximum is 2 million.</p>		<p>The LHEAP maximum is 2 million.</p>
	====Handling SQL statements greater than 32k bytes====		====Handling SQL statements greater than 32k bytes====

DCameron: /* Summary */

2014-12-02T14:51:17Z

Summary

← Older revision		Revision as of 14:51, 2 December 2014
Line 11:		Line 11:
	<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 V3.1</var>
	</dl>		</dl>

	==Description==		==Description==
	<p>The size of the HEAP storage area </p>		<p>The size of the HEAP storage area </p>

DmeWiccan: Automatically generated page update

2013-08-27T16:38:55Z

Automatically generated page update

← Older revision		Revision as of 16:38, 27 August 2013
Line 1:		Line 1:
			{{Template:LHEAP parameter subtitle}}
	==Summary==		==Summary==
	<dl>		<dl>

DmeWiccan: Automatically generated page update

2013-04-19T19:01:12Z

Automatically generated page update

← Older revision		Revision as of 19:01, 19 April 2013
Line 19:		Line 19:
	====Handling SQL statements greater than 32k bytes====		====Handling SQL statements greater than 32k bytes====
	<p>When handling an SQL statement that is greater than 32K, you must consider the LHEAP parameter. If its value is not large enough, the error message invoked includes the name of the relevant parameter. Rocket Software recommends setting LHEAP=200000 to handle SQL statements.</p>		<p>When handling an SQL statement that is greater than 32K, you must consider the LHEAP parameter. If its value is not large enough, the error message invoked includes the name of the relevant parameter. Rocket Software recommends setting LHEAP=200000 to handle SQL statements.</p>
	[[Category:Utable ~~Parameters~~]]		[[Category:Utable parameters]]
	[[Category:Parameters]]		[[Category:Parameters]]

Alex: Automatically generated page update

2013-02-28T00:56:05Z

Automatically generated page update

New page

==Summary==
<dl>
<dt>Default value
<dd>0
<dt>Parameter type
<dd>Utable
<dt>Where set
<dd>On user's parameter line
<dt>Related products
<dd>All
<dt>Introduced
<dd><var class="product">Model 204 V6.1</var> or earlier
</dl>
==Description==
The size of the HEAP storage area 
HEAP is a dynamic storage area included in the variable portion of the server area and required for the processing of SQL C routines. The size of HEAP is specified with the LHEAP parameter and is added to the variable size calculation of the server area. 
The initial value for SQL threads varies, based on your application requirements. Specify the initial value on the first IODEV line for IODEV=19. Do not specify it with the User 0 parameters, because this wastes space. For non-SQL threads, which do not require HEAP space, LHEAP can default to zero. 
The LHEAP maximum is 2 million.
====Handling SQL statements greater than 32k bytes====
When handling an SQL statement that is greater than 32K, you must consider the LHEAP parameter. If its value is not large enough, the error message invoked includes the name of the relevant parameter. Rocket Software recommends setting LHEAP=200000 to handle SQL statements.
[[Category:Utable Parameters]]
[[Category:Parameters]]