network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 4 months |
| seen | Feb 25 at 2:03 | |
| stats | profile views | 1 |
|
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 |
