Too Big: Burn CPU
Too Small: Burn IO

"The Database-Guys tools provide us with historical trending that gives us the ability to manage our system resources very effectively."

Mike Paris
Trans Union LLC

Flight Deck








Top Reasons
for Database-Guys Tools

Pool-GUY™ 1.4

U.S. Patent Pending

Features  |   Platforms
Software Requirements
Hardware Requirements
Vision  |  Tell Me More!

Sample Bufferpool Snapshot
Sample Tuning Analysis


Quickly discover 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 discover:

  • Bufferpools with best or worst hit ratios
  • Bufferpools with best or worst I/O performance

New!   Pool-GUY displays 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)


Pool-GUY processes 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 size.

The bottom line is that Pool-GUY will help you make informed decisions about appropriate bufferpool sizing.

Platforms Supported

Pool-GUY supports DB2 UDB versions 6.1, 7.x, and 8.1 for both Enterprise Edition (EE) and Extended Enterprise Edition (EEE).

DB2 UDB Enterprise Edition

DB2 UDB Extended Enterprise Edition


Supported Versions



5.1 (32-bit)


5.1 (64-bit) coming soon!
Sun Solaris®




Available now!
Linux® Intel

OS/390 coming soon!

HP-UX® HP-UX Inquire for details

Software Requirements

  • DB2 UDB per platforms listed
  • Operating system per platforms listed
  • A web browser capable of displaying HTML 3.2 documents
Hardware Requirements

Depending on bufferpool history retention requirements, an additional 1-10MB or more of disk space should be reserved for bufferpool performance data mart data.

Vision for the Future

We would enjoy the opportunity to discuss our future plans and directions with you. Please complete our additional information request form.

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.

Last Updated: Mon, 31 Mar 2003 14:14:33 EST

Home | Contact Us | Support | Top 10 Tips | Customer Feedback | Careers | Downloads
Live! Monitor Our Database!   |   Live! Monitor Our Tables!
White Papers and Other Resources

Copyright © 2003 Database-Guys. All rights reserved. Privacy and Legal details.