I am using db2 V9.5 ESE on windows.
In the health center I got a warning saying:
Health indicator name: database heap utilization
Description:
This indicator tracks the consumption of the monitor heap memory, based
on the memory pool with the ID SQLM_HEAP_DATABASE. The utilization is
calculated using the formula (db.pool_cur_size / db.pool_max_size) * 100
for the Memory Pool Identifier SQLM_HEAP_DATABASE. Once this percentage
reaches the maximum, 100%, queries and operations may fail because there
is no heap available.
Advisor suggests to increase the database heap size by updating the database configuration parameter ‘dbheap’. But it is already set to automatic. How can I modify this parameter to resolve the error???
Machine details are: windows 2003
RAM: 4GB
HardDisk: 400GB
There are hardly 3-4 applications running on the system.