64 [ 16 - 60 000 ] (multipartition)
This parameter defines the number of private memory pages available to be used by the database manager on behalf of a specific agent or subagent.
The heap is allocated when an agent or subagent is initialized for an application. The amount allocated will be the minimum amount needed to process the request given to the agent or subagent. As the agent or subagent requires more heap space to process larger SQL statements, the database manager will allocate memory as needed, up to the maximum specified by this parameter.
| Note: | In a partitioned database environment, the application control heap (app_ctl_heap_sz) is used to store copies of the executing sections of SQL statements for agents and subagents. SMP subagents, however, use applheapsz, as do agents in all other environments. |
Recommendation: Increase the value of this parameter if your applications receive an error indicating that there is not enough storage in the application heap.
The application heap (applheapsz) is allocated out of agent private memory.