Articles & Content


Effective DB2 for LUW Buffer Pool Strategies (C12)

Topic: 2007 EU

Subtopic: DB2 for LUW

DATE: 2007-11-7 (16:15 - 17:15)
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 the time to optimize this valuable resource.The presenter will talk of his experiences in tuning buffer pools for large applications including PeopleSoft, production applications, and data warehouses at client sites. Measurements and guidelines will be given.

EXP. LEVEL: Intermediate


The benefits of buffer pool tuning

Types of I/O

Block-based buffer pools

Number of buffer pools and object placement

Measuring buffer pool performance

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.