Agent Private Memory

The following parameters affect the amount of memory used for each database agent:

• Sort Heap Size (sortheap).
• Sort Heap Threshold (sheapthres).
• Statement Heap Size (stmtheap).
• Application Heap Size (applheapsz).
• Statistics Heap Size (stat_heap_sz).
• Query Heap Size (query_heap_sz).
• DRDA Heap Size (drda_heap_sz).
• UDF Shared Memory Set Size (udf_mem_sz).
• Agent Stack Size (agent_stack_sz).
• Minimum Committed Private Memory (min_priv_mem).
• Private Memory Threshold (priv_mem_thresh).
• Maximum Java Interpreter Heap Size (java_heap_sz). On UNIX-based platforms, java_heap_sz is allocated per agent.