IBM Mainframe Forum

All Buffer pools in DB2 system are full . How to increase the size of existing Buffer pool or how to increase the number of buffer pools ? Thanks first

Hello,

Suggest you work with your dba to determine why the buffers are full (other than they are supposed to be). Especially if things have worked well before some recent change.

If is not a good idea to go about just increasing things. . .

bufferpools are supposed to be (almost) full.

Hi kranthi_2k11

Suggest you to go throught the below topic.

"Alter Bufferpool"

Hope this will help you

Happy Learning

Suggest you to go throught the below topic.

"Alter Bufferpool"

any reason to suggest to alter the buffer pool sizes without having done a bit of analysis of the buffer pool behavior ???

I know the method to increase the VPSIZE of the particular Bufferpool.

I just give a hint to kranthi_2k11, there by kranthi_2k11 will learn some new things.

Thanks ..

Thanks .. got it and resolved ..

Hello,

Thanks .. got it and resolved ..

What does this mean. . .

The buffer pool is probably still almost full (if not completely full). . .