Buffer Pool Tuning

Date: 
Monday, 23 June, 2008 - 12:00 - 13:00
Speaker: 
Mike Bracey

Objectives:
DB2 buffer pools are a key resource for ensuring good performance. This is becoming increasingly important as the difference between processor speed and DASD response time for a random access IO widens in each new generation of processor. z/OS can be configured with large amounts of storage which, if used wisely, can help compensate by using storage to avoid IO.

The purpose of this session is to:
describe the functions of the DB2 buffer pools
outline four methods for measuring the performance of a buffer pool
make recommendations on how to set up and monitor the DB2 buffer pools

The session is intended for DB2 system administrators but may be of interest to any z/OS performance specialist. It is assumed that the attendee is familiar with DB2 and performance tuning but if that is not the case then the DB2 manual “Performance Monitoring and Tuning Guide” is recommended reading and can be found here:
http://www-306.ibm.com/software/data/db2/zos/library.html

Outline:
Bufferpool Functions and Operation
Instrumentation and Monitoring - Hit Ratio, Page Residency time, Reread Count
Buffer Pool Analyzer
Results from customer studies

Full Abstract:
This session will describe the primary functions and operation of the DB2 bufferpools including the parameters that are used to control their behaviour. Four methods for measuring the performance and efficiency of each pool are described along with their advantages and disadvantages. Recommendations are then made for how to use the bufferpools to ensure good performance. Lastly some resullts are used to illustrate the points discussed during the presentation

 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2020

VIRTUAL EVENT - 25th - 27th November 2020