DB2 graphic  QMF Version 8

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 DB2 UDB for z/OS SQL Reference. 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.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004