Create/alter bufferpool error with following settings:
Number of Block Pages = Null
Block Size = Null
Automatic = False
Wrong number of block pages.
If you run the following via the Editor, the command will run successfully:
CREATE BUFFERPOOL test
IMMEDIATE
ALL DBPARTITIONNUMS
SIZE 1000
PAGESIZE 8K;
Note that the above is the same as setting Automatic=False and Number of Block Pages and Block size to Null (or no values).
However, if you leave the "Number of Block Pages" and "Block size" to Null in the "Create Bufferpool" or "Alter Bufferpool" window, it will error out when you click Show Script. So basically, the issue is, DB2 accepts the command if the you do not specify any values on the 2 parameters above. Toad should also not error out.