Articles & Content


Bringing Bufferpool Tuning into the 21 century (B11)

Topic: 2006 EU

Subtopic: DB2 for z/OS

DATE: 2006-10-4 (14:45 - 15:45)

Many things have changed to your z/OS environment since most of the books on buffer pool tuning have been written. Most of us are now dealing with V8 or V7 on a 64 bit machine with large quantities of memory. Bring the new disk controllers and channel technology into the picture and all problems are gone? Not quite. This presentation will revisit the old buffer pool tuning myths and show how you need to approach the setting of the thresholds to maximize your benefits. More focus is put on the high availability of your system and that needs to be translated into the appropriate configuration of your pools and subsystem. Using data sharing has a significant impact on how to deal with your pools as the group buffer pools need to be considered.

EXP. LEVEL: Intermediate,Advanced


Understand the impact of the new disk technology on buffer pool tuning

Being able to translate availability and restart requirements into buffer pool tuning

Be able to identify how the buffer pool efficiency can be measured and validated

Tune the group buffer pools

Be able to determine how to assign DB2 objects to buffer pools

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.