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

bufferpool

P: n/a
Hi all,
Is there any recommended bufferpool size while designing database
I mean some equation which governs bufferpool size

regards,
Jagdip
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You're probably best to run the configuration advisor and or the design
advisor from the Control Center (right click on the database object) or
the db2advis command from the command line to get recommendations.

With no explanation of your workload or data, the answer in this
newsgroup can only be "it depends" - totally random access to data may
get little benefit from buffering data in memory, unless the amount of
memory if close to the amount of data, or the access is truly not random
- there is some pattern DB2 can exploit to pre-fetch hot data into the
bufferpool.

Predictable access can take advantage of well-configured bufferpools,
such as assigning a hot table to its own bufferpool, with enough memory
to keep the entire table in memory, or a transactional workload where
the same rows are frequently accessed.

Jagdip Singh wrote:
Hi all,
Is there any recommended bufferpool size while designing database
I mean some equation which governs bufferpool size

regards,
Jagdip


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.