Hi,
we are using db2ese v81 on a win2k server machine having 1GB memory.
On this machine only the dbms and the tomcat webserver are running.
We configured the dbms as recommended by "autoconfigure apply none",
e.g. <DBHEAP>=1400, <SORTHEAP>=2048. In addition, the dbms uses one
bufferpool consisting in 30,000 4K pages.
What we have observed is, after starting the database about 700MB of the
memory are free. In contrast, when we stress the database a little bit
it leads to significant reduction of freely avalaible memory. Ok, so far
so good. But, when we wait about 15 minutes, the memory which is freely
available will never be greater. It seems that the database does not
free the memory. This leads after several stressful queries to a freely
available memory of around 2MB.
At this point, the whole system is really slow. Every simple query needs
really long time and sometimes, the webserver hangs up.
Is there any enabler to free the unnessecary memory?
Best, Toralf