Articles & Content

Archives

Effective DB2 for LUW Buffer Pool Strategies (E06)

Topic: DB2 for LUW

Subtopic: 2009



DATE: 2009-5-13 (11:00 AM - 12:00 PM)
SPEAKERS: Martin Hubel (Martin Hubel Consulting, Inc.)

As applications grow, buffer pools play an increasingly important part in reducing physical I/O, elapsed time and CPU time. Many organizations have not spent time to optimize this valuable resource.The presenter will talk of his experiences in tuning buffer pools for large applications including production applications and data warehouses at client sites. Measurements, formulas and guidelines will be given.

EXP. LEVEL: Beginner

OBJECTIVES:

The benefits of buffer pool tuning- The need for tuning- A quantitative look at the benefits- Common mistakes and myths

Types of I/O- Random I/O- Sequential prefetch- List and dynamic prefetch- Block-based buffer pools- Data and index hit ratios

Number of buffer pools and object placement- Number and sizing of buffer pools- Table and indexes- Code and dimension tables- Placing very large objects

4.Measuring buffer pool performance- Buffer pool effectiveness formulas- Monitoring considerations- Tuning scenarios

5.Related tuning opportunities- Index design to reduce I/O- Data compression- Database reorganization



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.