Redpaper DB2 9 for z/OS: Buffer Pool Monitoring and Tuning
Hi DB2 User,
IBM just published a draft version of a new Redpaper, "DB2 9 for z/OS: Buffer Pool Monitoring and Tuning, REDP-4604-00":
http://www.redbooks.ibm.com/redpieces/abstracts/redp4604.html
Abstract
DB2® buffer pools are a key resource for ensuring good performance.This is becoming increasingly important as the difference between processor speed and disk response time for a random access I/O widens in each new generation of processor.A System z® processor can be configured with large amounts of storage which, if used wisely, can help compensate by using storage to avoid synchronous I/O.
The paper is intended to be read by DB2 system administrators but may be of interest to any z/OS® performance specialist. It is assumed that the reader is familiar with DB2 and performance tuning.
Table of Contents
- Describe the functions of the DB2 buffer pools
- Introduce a number of metrics for read and write performance of a buffer pool
- Make recommendations on how to set up and monitor the DB2 buffer pools
- Provide results from using this approach at a number of customers
More information
- Tuning DB2 at CGU Life
by Mike Barnard
- DB2 for z/OS Bufferpool Management
by Mike Bracey
- Buffer Pool Tuning for the New Large Memory World
by Joel Goldstein
- Redbook DB2 for OS/390 Capacity Planning, SG24-2244-00
Regards,
DB2usa.
<< Home