I just updated from 9.7 to 10.1, to leverage the new 4gig memory limitation. However, my app only appears to be using 2. So i searched for a way to find out how memory is used and found this command:
D:\DB2\scripts>db2pd -dbptnmem
Database Member 0 -- Active -- Up 0 days 04:40:54 -- Date 09/16/2012 14:37:08
Database Member Memory Controller Statistics
Controller Automatic: N
Memory Limit: 2097152 KB
Current usage: 2057664 KB
HWM usage: 2096960 KB
Cached memory: 390464 KB
Individual Memory Consumers:
Name Mem Used (KB) HWM Used (KB) Cached (KB)
========================================================
APPL-DOMINOS 2752 160000 1024
DBMS-DB2 109888 168832 0
FMP_RESOURCES 22528 22528 0
PRIVATE 20480 86656 9344
DB-MYAPPLI 1901760 1901760 380096
LCL-p5088 128 128 0
LCL-p5088 128 128 0
The line that really stands out is
Memory Limit: 2097152 KB
What does this mean? Why does my app not use 4 gig? How can I change it so that it does? Where does one configure this?
Best Answer
Found the answer in the doc (I should have RTM). You check the setting using:
And looking for INSTANCE_MEMORY, then update with: