We are on db2 udb v8.2 64 bit,partitioned (5 nodes)
on AIX 5.2 ( intra parllelism is enabled).
I have a question, i am trying to find the memory usage on my
production machine. what is the best tool to find memory usage in
db2??? (i've used db2mtrk, but it is no good in partitioned db)
I ran ps -e -o "%z %U %c" | sort -n i see lot of db2sysc processes , (i
also tried ps auwx) which cosume all the memory what are these
processes?
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
************************************************** ************************************************** ************************************************** **********
with the script posted by leonard the memory usage was 18 GB used
#!/usr/bin/sh
FIELD6=`ps auxw | grep -v defunct |grep db2 |sed -n '2,$'p | awk '{
print $5 }'`
TOTAL=0
for P in `echo $FIELD6`
do
TOTAL=`expr $TOTAL + $P`
done
TOTAL=`expr $TOTAL / 1048576`
echo "$TOTAL" GB
************************************************** ************************************************** ************************************************** **********
nmon shows memory used as 31.9 GB (i.e 90% of the memory is being
used)
************************************************** ************************************************** ************************************************** **********
from db2
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
sheptesth 4.5G
Total memory 12.2G
************************************************** ************************************************** ************************************************** **********
are my memory calculations correct? our db is partitioned (6 logical
nodes)
Also with db2stop vmstat shows most of the memory is being used, we
have no other applications running except db2
Any help greatly appreciated....
Thanks,
Raj