101 reputation
1
bio website
location
age
visits member for 2 years, 7 months
seen Feb 25 '13 at 2:03

Sep
17
comment Memory limitations on db2 express-c version 10.1 seems stuck at 2 gig, why?
If you do a get db cfg make sure SELF_TUNING_MEM is set to ON. Then run ALTER BUFFERPOOL buffpoolname SIZE AUTOMATIC. You can check current BP sizes via snapshots or with this query: SELECT DB_NAME, BP_NAME, BP_CUR_BUFFSZ as BP_CUR_PG_CNT, ((t.bp_cur_buffsz * bp_info.pagesize) /1048576) as BP_MEM_MB_SIZE FROM TABLE(SNAP_GET_BP_PART('dsrdbm01',-1)) AS T, syscat.bufferpools bp_info where t.bp_name = bp_info.bpname
Sep
17
comment Memory limitations on db2 express-c version 10.1 seems stuck at 2 gig, why?
Make sure your bufferpools are set to actually use the memory. AUTOMATIC should be the default but it's always a good thing to check.
Sep
2
awarded  Supporter