Mike Bracey

Speaker Details

Bio

Mike Bracey is part of the IBM Software Business in Europe providing technical support for DB2 for z/OS and related topics. He has extensive practical DB2 experience, gained over 18 years, of DB2 application design, data modelling, and performance monitoring and tuning. His recent roles have included technical support for IBM Data Management Tools and for the DB2 for z/OS beta programs in Europe.

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

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

Presentation will cover Intersect & Except, Instead of Triggers, Merge, Select from Merge, Update and Delete, Truncate, Order by and Fetch first in subselect; the new data types. Same presentation will be conducted at the DB2 Technical conference in Dusseldorf.

Presentation will be based on the material presented by Guogen Zhang at the Anaheim IOD and it will include some worked examples. Simple demonstration wil be included in presentation accordingly to the network access. Primary goal would be to show that XML in V9 is a straightforward extension of existing relational technology, is simple to use and it works well.