Understanding the advantages of DB2 9 autonomic computing features

(Mohankumar Saraswatipura and Swetha Prasad) The self tuning memory manager (STMM) is a revolutionary memory tuning feature that was first introduced in IBM DB2 9. The STMM eases the task of memory configuration by automatically setting optimal values for most memory configuration parameters, including buffer pools, package cache, locking memory, sort heap, and total database shared memory. When STMM is enabled, the memory tuner dynamically distributes the available memory among the various memory consumers. This article explains the function of the STMM, teaches you to enable the feature, and also discusses how STMM can bring real benefits to your business environment.