which bufferpools have the best and worst performance
statistics. Pool-GUY performs all the tedious calculations so you can
focus your efforts on improving performance.
Using Pool-GUY, you can quickly find out for each bufferpool:
- Size in megabytes (not pages!)
- Overall and Index hit ratios
- Average read times (ms)
- Average write times (ms)
- Physical reads per minute
- Percentage of asynchronous or synchronous reads
- Percentage of asynchronous or synchronous writes
- Number of files closed!
You can sort the displays by any criteria allowing you to quickly
- Bufferpools with best or worst hit ratios
- Bufferpools with best or worst I/O performance
come in two varieties:
Additionally, Pool-GUY will help you identify ideal values for:
- Bufferpool sizes
- Number of asynchronous page cleaners (NUM_IOCLEANERS)
- Changed pages threshold (CHNGPGS_THRESH)
- Max DB files open per application (MAXFILOP)
the volumes of output from 'get snapshot for bufferpools on DBNAME'
and computes the relevant performance variables for consolidated display.
All performance values are also saved in a bufferpool statistics
data mart table. Ad hoc queries can be run against this table to ascertain
trends and the effectiveness of a given bufferpool at any given configured
The bottom line is that Pool-GUY will help you make informed decisions
about appropriate bufferpool sizing.
DB2 UDB versions 6.1, 7.x, and 8.1 for both Enterprise Edition (EE)
and Extended Enterprise Edition (EEE).
Extended Enterprise Edition
(64-bit) coming soon!
- DB2 UDB per platforms listed
- Operating system per platforms listed
- A web browser capable of displaying HTML 3.2 documents
bufferpool history retention requirements, an additional 1-10MB or
more of disk space should be reserved for bufferpool performance data
Vision for the Future
We would enjoy
the opportunity to discuss our future plans and directions with you.
Please complete our additional information
I Want More!
If you'd like
more information on Pool-GUY or any of Database-Guys's products, please complete
our Tell Me More! form.