By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,347 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

memory usage

P: n/a
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.

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

hi****@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.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.