The db2fmp is the JVM for java fenced udfs and stored procs. Do you have
possible leaks in the SP's ? or
maybe just a continual growth? The db2sysc is the database engine, it may
be large but should be ok
from a growth standpoint.
The aslheapsz is a parm you could look at to reduce the memory for each
fmp, but it sounds like you could
have a leak and maybe should open a pmr.
If you only have a total of 2 GB Ram , take a look at your bufferpools
and reduce the sizes where appropriate.
"Sudhir Anand -
CTS "
<db2udbdba-ezmlms To
hield-x24749681.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc
11/23/2005 10:47 Subject
AM URGENT ANSWER APPRECIATED
PLEASE URGENT ANSWER REQUIRED AS THIS IS A PROBLEM EXIST WITH THE
PRODUCTION
SERVER....
============================================================================
======
We are running the database on db28.1.10
db2syscs.exe and db2fmp.exe is chewing up machine memory. The machine has 2
GB RAM and 124 GB HDD with 100GB free.
What parameters we should set to reduce the memory usauge. And please let
me
know what these processes do ..
And what parameters we should set to kill the un-used the processes so that
server memory will be reduced and it doesn't chew the system...
--sudhir
----------------------------------------------------------------------------
---------------------------------------------------
DISCLAIMER
This email and any files transmitted with it are confidential and are
solely
for the use of the individual or entity to which it is addressed. Any use,
distribution, copying or disclosure by any other person is strictly
prohibited. If you receive this transmission in error, please notify the
sender by reply email and then destroy the message. Opinions, conclusions
and other information in this message that do not relate to official
business of the company shall be understood to be neither given nor
endorsed
by NIIT Ltd. or NIIT Technologies Ltd. Any information contained in this
email, when addressed to Clients is subject to the terms and conditions in
governing client contract.
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page