Reputation
Next privilege 125 Rep.
Vote down
Badges
1
Newest
 Supporter
Impact
0 people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
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