I am trying to find the memory usage in db2, i've posted several topics
here but never found the answer,I would really appreciate any help ...
my question is i see 95 % of memory on my production machine being
used, but can't find what db2 processes are using it up?
even with a db2stop i see 50 % memory being used ( i used nmon, vmstat
to find the memory usage [all i can see is some db2sysc and db2fmp
process use up the mem]...
i don't have access to svmon) below are the output of vmstat, and
db2mtrk
The vmstat -v o/p
************************************************** **********************************
8388608 memory pages
7945351 lruable pages
324911 free pages
1 memory pools
791671 pinned pages
80.1 maxpin percentage
5.0 minperm percentage
40.0 maxperm percentage
49.6 numperm percentage
3942204 file pages
0.0 compressed percentage
0 compressed pages
39.3 numclient percentage
40.0 maxclient percentage
3122831 client pages
0 remote pageouts scheduled
0 pending disk I/Os blocked with no pbuf
6841 paging space I/Os blocked with no psbuf
961934 filesystem I/Os blocked with no fsbuf
0 client filesystem I/Os blocked with no fsbuf
411762361 external pager filesystem I/Os blocked with no
fsbuf
************************************************** ****************************
from db2 ( for 6 partitions)
----------------------------------------------------------------------------------------------------------------------------
Mem Memory # of Current
Type Pool Pool(s) Size
---- -------------------- ------- ------------
Inst Monitor 6 1M
Inst FCMBP 6 483.8M
Inst Other 6 167.4M
Db Database 6 110M
Db Appl Control 60 367.9M
Db Lock Mgr 6 248.2M
Db Utility 6 96K
Db Package Cache 6 20.1M
Db Catalog Cache 6 2.7M
Db Other 6 192K
Db BufferPool 60 4.6G
Db ApplGroup 12 849.7M
Db SharedSort 6 0
Appl Applications 260 19.7M
Appl Other 260 371.9M
Total memory 7.7G
(sheptesth 4.5G )
--------------------------------------------------------------------------------------------------------------------------
Thanks,
Raj