LHEAP parameter

From m204wiki
Revision as of 14:51, 2 December 2014 by DCameron (talk | contribs) (→‎Summary)
Jump to navigation Jump to search

Length of heap

Summary

Default value
0
Parameter type
Utable
Where set
On user's parameter line
Related products
All
Introduced
Model 204 V3.1

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.