DB2 11 for z/OS Buffer Pool Monitoring and Tuning

rb170x32 – DRAFT

DB2 11 for z/OS Buffer Pool Monitoring and Tuning

DB2® buffer pools are still a key resource for ensuring good performance. This has become 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. Several changes in buffer pool management have been provided by DB2 10 and DB2 11.
The purpose of this Redpaper is to:
– Describe the functions of the DB2 11 buffer pools
– Introduce a number of metrics for read and write performance of a buffer pool
– Provide information on how to set up and monitor the DB2 buffer pools
The paper is intended to be read by DB2 system administrators but it may be of interest to any z/OS® performance specialist. It is assumed that the reader is familiar with DB2 and performance tuning.
In this paper, we also assume that you are somewhat familiar with DB2 11 for z/OS performance. See DB2 11 for z/OS Technical Overview, SG24-8180 and DB2 11 for z/OS Performance Topics, SG24-8222, for more information on DB2 11 functions and their performance.

Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s