By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,226 Members | 1,032 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,226 IT Pros & Developers. It's quick & easy.

Bufferppol size...-1

P: n/a
Hi,

What size is set for the bufferpool when "alter bufferpool....size -1
" is issued.

Deogirikar.

Sep 19 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
<g.**********@gmail.comwrote in message
news:11*********************@k35g2000prh.googlegro ups.com...
Hi,

What size is set for the bufferpool when "alter bufferpool....size -1
" is issued.

Deogirikar.
There is a parm in the db config that is used. This should not be used since
IBM has said it is being depreciated and eventually will go away.
Sep 19 '07 #2

P: n/a
On Sep 19, 7:41 am, g.deogiri...@gmail.com wrote:
Hi,

What size is set for the bufferpool when "alter bufferpool....size -1
" is issued.

Deogirikar.
Well, I dont know what it means when you "alter bufferpool.. size -1",
but when you have automatic storage turned on (SIZE AUTOMATIC),
syscat.bufferpool reports -2 for NPAGES.

Cheers,

Sep 19 '07 #3

P: n/a
On Sep 19, 2:22 pm, Sanjuro <ashru...@gmail.comwrote:
On Sep 19, 7:41 am, g.deogiri...@gmail.com wrote:
Hi,
What size is set for the bufferpool when "alter bufferpool....size -1
" is issued.
Deogirikar.

Well, I dont know what it means when you "alter bufferpool.. size -1",
but when you have automatic storage turned on (SIZE AUTOMATIC),
syscat.bufferpool reports -2 for NPAGES.

Cheers,
If you alter a buffer pool's size to -1, it will use as its size, the
value in the BUFFPAGE database configuration parameter. Generally,
this isn't advisable however, as the buffpage configuration parameter
is obsolete.

Search for buffpage here:

http://publib.boulder.ibm.com/infoce...c/r0008109.htm

Thanks,
Adam

Sep 20 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.