db2 - How to cretae Buffer Pool in Database dedicated only for ONE BIG table? -

db2 - How to cretae Buffer Pool in Database dedicated only for ONE BIG table? -

i have table ticket 400k records in database (db2).

i wish create 1 huge buffer pool dedicated 1 big table faster response. steps it?

also @ moment have 1 buffer pool coovers whole table space tables (about 200) in database! happen specific table in old firstly created buffer pool? should table remain in first buffer pool or how remove buffer pool?? there risks action???

thank you

i think article help you: http://www.ibm.com/developerworks/data/library/techarticle/0212wieser/index.html

moving big table different buffer pool may increment performance, depends on utilize case. relevant quote article:

having more 1 buffer pool can preserve info in buffers. example, might have database many very-frequently used little tables, in buffer in entirety accessible quickly. might have query runs against big table uses same buffer pool , involves reading more pages total buffer size. when query runs, pages small, used tables lost, making necessary re-read them when needed again. if little tables have own buffer pool, thereby making necessary them have own table space, pages cannot overwritten big query. can lead improve overall scheme performance, albeit @ cost of little negative effect on big query.

if decide this, can have 1 buffer pool per tablespace, need move big table own tablespace. article gives examples of creating tablespaces , buffer pools.

a table can moved tablespace admin_move_table. don't think risky. captures changes may made source table during moving. thing disable few (rarely used) actions on source table during moving.

you assign buffer pool tablespace specifying in create tablespace or alter tablespace statement.

db2 buffer tablespace