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

Self tuning bufferpool

P: n/a
In 9.1 and 9.5 (Linux 64 bit) when a buffer pool is set to self-
tuning, how are blocks configured in respect to blocked vs non-blocked
when self-tuning is set to on?

(ie) I have one bufferpool that is 16k that the IBMDEFAULTBP is shared
between all tablespaces.
The data tablespace has prefetch automatic set to on.
Sep 26 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Ian
dunleav1 wrote:
In 9.1 and 9.5 (Linux 64 bit) when a buffer pool is set to self-
tuning, how are blocks configured in respect to blocked vs non-blocked
when self-tuning is set to on?

(ie) I have one bufferpool that is 16k that the IBMDEFAULTBP is shared
between all tablespaces.
The data tablespace has prefetch automatic set to on.
STMM will not tune the size of the block-based area of a bufferpool.

Sep 26 '08 #2

P: n/a
On Sep 26, 3:15*pm, Ian <ianb...@mobileaudio.comwrote:
dunleav1 wrote:
In 9.1 and 9.5 (Linux 64 bit) when a buffer pool is set to self-
tuning, how are blocks configured in respect to blocked vs non-blocked
when self-tuning is set to on?
(ie) I have one bufferpool that is 16k that the IBMDEFAULTBP is shared
between all tablespaces.
The data tablespace has prefetch automatic set to on.

STMM will not tune the size of the block-based area of a bufferpool.
I can't seem to set a block based area in a bufferpool that is self
tuning.
I can't set a large initial size for the bufferpool area either. When
I set a size and recycle the database, the
initial size defaults back to 1000 16k when using self tuning.

Isn't it possible to allocate a larger initial bufferpool area, and to
use block-based bufferpools when using self tuning memory?
Sep 29 '08 #3

P: n/a
Ian
dunleav1 wrote:
I can't seem to set a block based area in a bufferpool that is self
tuning.
create bufferpool bp
size 100000 automatic
numblockpages 1000
pagesize 4096
I can't set a large initial size for the bufferpool area either. When
I set a size and recycle the database, the
initial size defaults back to 1000 16k when using self tuning.
alter bufferpool yourbp size 100000 automatic numblockpages 1000
Keep in mind, DB2 may reduce the size of the bufferpool if it doesn't
see demand for it.
Isn't it possible to allocate a larger initial bufferpool area, and to
use block-based bufferpools when using self tuning memory?
Yes. But as I said, the number of block pages is fixed when the
bufferpool is allocated. So, while STMM may grow (and shrink) the
size of the page-based area of the bufferpool, the block-based
area will remain fixed.
Sep 29 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.