DB2 Version 9.7 for Linux, UNIX, and Windows

stat_heap_sz - Statistics heap size configuration parameter

This parameter indicates the maximum size of the heap used in collecting statistics using the RUNSTATS command. The constraint set by this parameter applies to each RUNSTATS operation.

With Version 9.5, this database configuration parameter has a default value of AUTOMATIC, meaning that it increases as needed until either the appl_memory limit is reached, or the instance_memory limit is reached.

Configuration type: Database
Parameter type: Configurable online
Default [range]: Automatic [1 096 - 524 288]; Note: The default value is subject to change by the DB2® Configuration Advisor after initial database creation.
Unit of measure: Pages (4 KB)
When allocated: When the RUNSTATS utility is started
When freed: When the RUNSTATS utility is completed

Recommendation: The default setting of AUTOMATIC is recommended.

Recommendation: RUNSTATS memory requirements depend on several factors. More memory is utilized with more statistic options, for example if LIKE statistics or DETAILED index statistics are being collected. When column statistics are collected, gathering statistics of a higher number of columns will utilize more memory. When distribution statistics are being collected, gathering a higher number of frequent and/or quantile values will utilize more memory. The default setting of AUTOMATIC is recommended.