To use database memory efficiently when the Self Tuning
Memory Manager (STMM) is set, you must determine the optimal value
of DATABASE_MEMORY parameter.
Procedure
- Log in with the database instance owner credentials.
- Stop the directory server instance.
- Verify that the DATABASE_MEMORY parameter
is set to AUTOMATIC.
- On Solaris and Linux systems,
stop and start DB2®. DB2 adjusts the size of DATABASE_MEMORY when DB2 starts.
- Run the system under normal loads to determine the optimal
size of DATABASE_MEMORY for the workload.
- To view the value that is set for DATABASE_MEMORY by DB2, run the following command:
db2 get db cfg show detail
- To optimize performance, change the DATABASE_MEMORY parameter
value with the value determined by DB2 instead
of AUTOMATIC.
- On Solaris and Linux systems,
stop and start DB2.
- Run the system under normal load again.
Results
On Solaris and Linux systems, DB2 adjusts the size of
DATABASE_MEMORY when DB2 starts. On Windows and AIX® systems, DB2 adjusts the size of
DATABASE_MEMORY while
the system is under load.