470,855 Members | 1,163 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,855 developers. It's quick & easy.

db2 memory

Raj
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

Feb 21 '06 #1
1 2284
Try the DB2MTRK command for coarse info. or DB2PD command for fine detail.
HTH, Pierre

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Raj" <sp****@yahoo.com> a écrit dans le message de news:
11**********************@g47g2000cwa.googlegroups. com...
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

Feb 21 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Frank Esser | last post: by
4 posts views Thread by Franklin Lee | last post: by
9 posts views Thread by Mike P | last post: by
22 posts views Thread by xixi | last post: by
14 posts views Thread by Alessandro Monopoli | last post: by
1 post views Thread by Nick Craig-Wood | last post: by
1 post views Thread by Jean-Paul Calderone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.