Unix Technical Forum

memory usage

This is a discussion on memory usage within the DB2 forums, part of the Database Server Software category; --> db2pd -memsets shows below: Memory Sets: Name Address Id Size Key DBP Type Ov OvSize DBMS 0x30000000 131074 33554432 ...


Go Back   Unix Technical Forum > Database Server Software > DB2

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 05:36 AM
hikums@gmail.com
 
Posts: n/a
Default memory usage

db2pd -memsets shows below:
Memory Sets:
Name Address Id Size Key DBP Type
Ov OvSize
DBMS 0x30000000 131074 33554432 0x89F69C61 0 0
Y 5455872
FMP 0x90000000 131073 245284864 0x0 0 2
N 0
Trace 0xC0000000 131075 140665792 0x89F69C74 0 -1
N 0

Why is FMP using more memory than DBMS? Will it provide better
performance if I tune this to allow more for DBMS and less for FMP?

Thanks for your insight.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 05:39 AM
Ben Eisenstein
 
Posts: n/a
Default Re: memory usage

The FMP is storage reserved for fenced processes. You did not mention
your operating system, but it looks to be UNIX. In a 32-bit memory
model, DB2 will reserve a whole segment if fenced processes are being
used. It looks like db2pd is showing the whole segment size. I just
checked on my system and it looks similiar.

Ben Eisenstein
DB2 LUW and z/OS IBM Certified Solutions Expert

hikums@gmail.com wrote:
> db2pd -memsets shows below:
> Memory Sets:
> Name Address Id Size Key DBP Type
> Ov OvSize
> DBMS 0x30000000 131074 33554432 0x89F69C61 0 0
> Y 5455872
> FMP 0x90000000 131073 245284864 0x0 0 2
> N 0
> Trace 0xC0000000 131075 140665792 0x89F69C74 0 -1
> N 0
>
> Why is FMP using more memory than DBMS? Will it provide better
> performance if I tune this to allow more for DBMS and less for FMP?
>
> Thanks for your insight.
>

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:11 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com