Altering a buffer pool

Use the Alter Buffer pool window to change the attributes of the buffer pool that you have selected.

Authorities and privileges

To alter a buffer pool:

  1. Open the Alter buffer pool window.

  2. Place your cursor in the field you want to change. The fields on this window relate to sizes and thresholds of the buffer pool or hiperpool.

  3. Type a valid number that reflects the new size. Each field has a range from 0 to some number of kilobytes. The exception is for BP0, which requires a minimum of 56KB. If you set Virtual buffer pool size to 0 for an active buffer pool, you have deleted the buffer pool. DB2 for OS/390 quiesces all current database access and fails all subsequent page set open requests.

  4. Repeat the above 2 steps for any additional fields that you want to change.

  5. Select one of the following Discard hiperpool data radio buttons:

    Yes
    MVS discards the data cached in the hiperpool when a shortage of expanded storage arises.
    No
    MVS assigns a high priority to keeping the data cached in the hiperpool. You should select No only for buffer pools associated with databases for which response time is critical.

  6. Click OK to apply the change and close this window.

Related information