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;