Updating DB2® self-tuning memory manager (STMM) settings | HCL Digital Experience
With the Version 8.5 release, a number of the settings have been changed to be managed by the self-tuning memory manager (STMM) engine. Change your settings to the recommended values, if there are no specific needs for the current values.
Procedure
- Stop the portal server.
- Change your 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 only for the database that contains the JCR Domain: UPDATE DB CFG FOR dbname USING logfilsiz 16000;
- Required only for the database that contains the JCR Domain: UPDATE DB CFG FOR dbname USING logprimary 20;
- Required only for the database that contains the JCR Domain: UPDATE DB CFG FOR dbname USING logsecond 50;
- Required only for the database that contains the JCR Domain: UPDATE DB CFG FOR dbname USING logbufsz 500;
- Connect to your database.
db2 connect to dbdomain.DbName user dbdomain.DBA.DbUser using dbdomain.DBA.DbPassword
Note:- For dbdomain.DbName, enter the name of the portal domain database.
- For dbdomain.DBA.DbUser, enter the name of the database administrator user ID for privileged access operations during database creation and setup.
- For dbdomain.DBA.DbPassword, enter the database administrator password for privileged access operations during database creation.
- Change your settings to the recommended bufferpool values:
- ALTER BUFFERPOOL ICMLSFREQBP4 SIZE automatic;
- ALTER BUFFERPOOL ICMLSVOLATILEBP4 SIZE automatic;
- ALTER BUFFERPOOL ICMLSMAINBP32 SIZE automatic;
- ALTER BUFFERPOOL CMBMAIN4 SIZE automatic;