Switching buffer pools

For performance reasons, you might want to change the buffer pool for a table space containing a control table or for a control table index. For example, if your installation is strongly QMF oriented, you might 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 queries. For descriptions of these queries and the authorities needed to run them, see the DB2 UDB for OS390 SQL Reference manual. You can choose BP0, BP1, or BP2 for your new buffer pool, but not BP32K.

There are other parameters whose values you can change with ALTER TABLESPACE and ALTER INDEX queries. Of these, only the DSETPASS parameters can be changed without damaging the operability of QMF.