Update DB2 self-tuning memory manager (STMM) settings

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