Switching buffer pools

For performance reasons, you might want to change the buffer pool for a table space containing a QMF control table or for a control table index.

For example, you could switch the buffer pools for the control table indexes and table spaces to BP1, and reserve BP1 for their exclusive use.

You change buffer pools through ALTER TABLESPACE and ALTER INDEX statements. You can choose BP0, BP1, or BP2 for your new buffer pool, but not BP32K.