473,461 Members | 1,927 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

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 2507
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Andreas Suurkuusk | last post by:
Hi, I just noticed your post in the "C# memory problem: no end for our problem?" thread. In the post you implied that I do not how the garbage collector works and that I mislead people. Since...
4
by: Frank Esser | last post by:
I am using SQL 8 Personal edition with sp2 applied. I set the max server memory to 32MB and leave the min server memory at 0. When my application starts hitting the database hard the memory usage...
4
by: Franklin Lee | last post by:
Hi All, I use new to allocate some memory,even I doesn't use delete to release them. When my Application exit, OS will release them. Am I right? If I'm right, how about Thread especally on...
9
by: Mike P | last post by:
I know everything about reference counting and making sure you don't have large objects lying around. I have also profiled my app with multiple tools. I know about the fact GC collects memory but...
22
by: xixi | last post by:
hi, we are using db2 udb v8.1 for windows, i have changed the buffer pool size to accommadate better performance, say size 200000, if i have multiple connection to the same database from...
14
by: Alessandro Monopoli | last post by:
Hi all, I'm searching a PORTABLE way to get the available and total physical memory. Something like "getTotalMemory" and it returns the memory installed on my PC in bytes, and...
1
by: Nick Craig-Wood | last post by:
I've been dumping a database in a python code format (for use with Python on S60 mobile phone actually) and I've noticed that it uses absolutely tons of memory as compared to how much the data...
5
by: kumarmdb2 | last post by:
Hi guys, For last few days we are getting out of private memory error. We have a development environment. We tried to figure out the problem but we believe that it might be related to the OS...
1
by: Jean-Paul Calderone | last post by:
On Tue, 22 Apr 2008 14:54:37 -0700 (PDT), yzghan@gmail.com wrote: The test doesn't demonstrate any leaks. It does demonstrate that memory usage can remain at or near peak memory usage even after...
5
by: cham | last post by:
Hi, I am working on c++ in a linux system ( Fedora core 4 ), kernel version - 2.6.11-1.1369_FC4 gcc version - 4.0.0 20050519 ( Red Hat 4.0.0-8 ) In my code i am creating a vector to store...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.