Update DB2 self-tuning memory manager (STMM) settings
With the v8.5 release, a number of the settings have been changed to be managed by the self-tuning memory manager (STMM) engine. Change the settings to the recommended values, if there are no specific needs for the current values.
Change the settings to the recommended values:
UPDATE DBM CFG USING sheapthres 0;
For each Portal database (release, community, customization, jcr, feedback, likeminds):
- UPDATE DB CFG FOR dbname USING applheapsz automatic;
- UPDATE DB CFG FOR dbname USING stmtheap automatic;
- UPDATE DB CFG FOR dbname USING dbheap automatic;
- UPDATE DB CFG FOR dbname USING locklist automatic;
- UPDATE DB CFG FOR dbname USING avg_appls automatic;
- UPDATE DB CFG FOR dbname USING PCKCACHESZ automatic;
- UPDATE DB CFG FOR dbname USING AUTO_MAINT on;
- UPDATE DB CFG FOR dbname USING SHEAPTHRES_SHR automatic;
- UPDATE DB CFG FOR dbname USING SORTHEAP automatic;
- UPDATE DB CFG FOR dbname USING SELF_TUNING_MEM ON;
- Required for JCR only: UPDATE DB CFG FOR dbname USING logfilsiz 16000;
- Required for JCR only: UPDATE DB CFG FOR dbname USING logprimary 20;
- Required for JCR only: UPDATE DB CFG FOR dbname USING logsecond 50;
- Required for JCR only: UPDATE DB CFG FOR dbname USING logbufsz 500;
- ALTER BUFFERPOOL @WPLC32KBP@ SIZE automatic;
- ALTER BUFFERPOOL @WPLC8KBP@ SIZE automatic;
- ALTER BUFFERPOOL @WPLC4KBP@ SIZE automatic;
- ALTER BUFFERPOOL ICMLSFREQBP4 SIZE automatic;
- ALTER BUFFERPOOL ICMLSVOLATILEBP4 SIZE automatic;
- ALTER BUFFERPOOL ICMLSMAINBP32 SIZE automatic;
- ALTER BUFFERPOOL CMBMAIN4 SIZE automatic;
Parent Database tasks