Articles & Content

Archives

Tuning Group Buffer Pools - 1 Command, 1 Worksheet: Part 1 of 2 (J04)

Topic: 2005 NA

Subtopic: DB2 for z/OS



DATE: 2005-05-23 (03:30 PM - 04:40 PM)
SPEAKERS: Bryce Krohn (Krohn Enterprises, Inc.)

This presentation presents a methodology for tunimg group buffer pools - an important part of DB2 data sharing. The detailed mechanics of the group buffer pools will be covered, along with a detailed explanation of the DISPLAY GROUPBUFFERPOOL command. In addition, a performance tool spreadsheet will be discussed, (and included in the presentation), that will graphically assist in planning and tracking the tuning effort.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

GBP Mechanics

D GBPOOL GDETAIL

D GBPOOL MDETAIL

Spreadsheet Tool

Getting the RED out - Tuning the GBPs



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.