How to change the number of buffers in a buffer pool

If a buffer pool is too small, as may be shown by message CSQP020E on the console, we can allocate more buffers to it using the ALTER BUFFPOOL command as follows:

1. Determine how much space is available for new buffers by looking at the CSQY220I messages in the log. The available space is reported in MB. As a buffer has a size of 4 KB, each MB of available space allows you to allocate 256 buffers. Do not allocate all the free space to buffers, as some is required for other tasks.

2. If the reported free space is inadequate, release some buffers from another buffer pool using the command

   ALTER BUFFPOOL(buf-pool-id) BUFFERS(integer)

   where buf-pool-id is the buffer pool from which you want to reclaim space and integer is the new number of buffers to be allocated to this buffer pool, which must be smaller than the original number of buffers allocated to it.

3. Add buffers to the buffer pool you want to expand using the command

   ALTER BUFFPOOL(buf-pool-id) BUFFERS(integer)

   where buf-pool-id is the buffer pool to be expanded and integer is the new number of buffers to be allocated to this buffer pool, which must be larger than the original number of buffers allocated to it.