Articles & Content
Topic: DB2 for LUW
DATE: 2006-10-3 (09:00 - 10:00)
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: Beginner,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
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.