Altering buffer pools
The characteristics of buffer pools that you can change are: the buffer's size, the automatic sizing, database partition groups, and block area. Other attributes cannot be changed, apart from dropping and recreating the buffer pool with the desired specifications.
Getting ready
Depending on what you want to change, you may need down time to restart the database.
How to do it...
In our last example, we wanted to use prefetching in this buffer pool. We defined only 20 pages (20 x 32 KB = 640 KB). We want to alter it to 1280 KB, which will give us 10 blocks:
[db2inst1@nodedb21 nav]$ db2 "alter bufferpool nav_bpt32k numblockpages 40 blocksize 4" SQL20149W The buffer pool operation has been completed but will not take effect until the next database restart. SQLSTATE=01649
How it works...
Note here that the change has been made, but we need to restart the database so the change takes effect.
[db2inst1@nodedb21 nav]$ db2 "select substr(bpname,1,15) bpname,npages,pagesize, numblockpages...
