SAP Note 1132282 - DB6: Use of Self Tuning Memory Manager (STMM) for SAP NW BW

Component : BW DB2 Universal Database -

Solution : https://service.sap.com/sap/support/notes/1132282 (SAP Service marketplace login required)

Key words :
database_memory automatic locklist        automatic maxlocks        automatic pckcachesz      automatic sortheap        automatic sheapthres_shr  automaticto set instance_memory, locklist        automatic maxlocks        automatic pckcachesz      automatic sortheap        automatic sheapthres_shr  automatic, db2 alter bufferpool <bp_name> size automatic 4, db2 alter bufferpool <bp_name> dbpartitionnum <, disabling stmm - additional informationto switch, sheapthres 0db2 update db cfg, db2 release-dependent stmm settings, db2 update dbm cfg, <<+0< db2 update db cfg, db2 update db cfg

Related Notes :

1329179DB6: DB2 9.7 Standard Parameter Settings
1086130DB6: DB2 9.5 Standard Parameter Settings
899322DB6: DB2 9.1 Standard Parameter Settings