Skip to Content
Former Member
Aug 24, 2010 at 03:24 AM

Default value for bufferpools "IBMDEFAULTBP"


Dear gurus,

I check in one of my system that default bufferpool IBMDEFAULTBP is so small, around 16MB, where in other system it's up to 1.2GB.

The configuration is STMM enabled, and IBMDEFAULTBP is set to automatic.

When I alter bufferpool using this command: "alter bufferpool ibmdefaultbp size 10000 automatic", there is error

SQL20150n: The number of block pages for a buffer pool is too large for the size of the buffer pool.

Is it possible to recreate the IBMDEFAULTBP bufferpools? Because when I create another bufferpool with the same DB2 syntax, it's ok.

And when I create new bufferpools, how do you configure that tablespace using the newly created bufferpool?

Thanks for your help.

Best Regards,