Have you tried setting DB2MEMDISCLAIM and DB2MEMMAXFREE?

-----Original Message-----
From: Joe Philip [mailto:joe.[Email Address Removed] Monday, April 12, 2004 10:07 AM
To: [Email Address Removed] db2 agents take too much memory and not release the memory
after becoming idle


We run DB2 udb v 8.1 on HP-UX 11.11. It seems like each db2 agent is grabbing some amount of memory and even the agent becomes idle, it is still holding the same amount of memory. In our case, the memory used by each db2agent is growing as the week progress and we have to stop the instance after a while to get the memory back to the system.

What paramter can I set so that the db2agent releases the memory once the process is completed.



---------------------------------------------------------
This e-mail transmission may contain information that is proprietary, privileged and/or confidential and is intended exclusively for the person(s) to whom it is addressed. Any use, copying, retention or disclosure by any person other than the intended recipient or the intended recipient's designees is strictly prohibited. If you are not the intended recipient or their designee, please notify the sender immediately by return e-mail and delete all copies.

---------------------------------------------------------

DB2 & UDB email list listserv db2-l LazyDBA home page