Articles & Content

Archives

Bringing Bufferpool Tuning into the 21 century (B11)

Topic: DB2 for z/OS

Subtopic: 2006



DATE: 2006-10-4 (14:45 - 15:45)
SPEAKERS: Jan Henderyckx (BRAINWARE )

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

OBJECTIVES:

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



Click Here to Download

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