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 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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. |
| ||||
| 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. > |