Page 1 of 1
Buffer pool full
Posted:
Sat Nov 12, 2011 1:13 pm
by kranthi_2k11
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
Re: Buffer pool full
Posted:
Sun Nov 13, 2011 9:58 am
by dick scherrer
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. . .
Re: Buffer pool full
Posted:
Mon Nov 14, 2011 2:17 pm
by GuyC
bufferpools are supposed to be (almost) full.
Re: Buffer pool full
Posted:
Mon Nov 14, 2011 3:21 pm
by db2sysdba
Hi kranthi_2k11
Suggest you to go throught the below topic.
"Alter Bufferpool"
Hope this will help you
Happy Learning
Re: Buffer pool full
Posted:
Mon Nov 14, 2011 4:55 pm
by enrico-sorichetti
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 ???
Re: Buffer pool full
Posted:
Mon Nov 14, 2011 7:58 pm
by db2sysdba
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.
Re: Buffer pool full
Posted:
Tue Nov 15, 2011 6:31 pm
by kranthi_2k11
Thanks ..
Re: Buffer pool full
Posted:
Tue Nov 15, 2011 6:32 pm
by kranthi_2k11
Thanks .. got it and resolved ..
Re: Buffer pool full
Posted:
Tue Nov 15, 2011 11:11 pm
by dick scherrer
Hello,
Thanks .. got it and resolved ..
What does this mean. . .
The buffer pool is probably still almost full (if not completely full). . .