Articles & Content

Archives

Optimize DB2 Buffer Pool performance with the new Performance Wizard, and Buffer Pool Tool for DB2 (F09)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2010



DATE: 2010-5-13 (08:30 AM - 09:30 AM)
SPEAKERS: Joel Goldstein (Responsive Systems)

Effective pool tuning offers great opportunities for improving both system and application performance. Aside from the elapsed time and cpu savings from I/O elimination, this process often highlights significant application performance problems. This presentation will take you through the steps of analysis and tuning using the industry standard Buffer Pool Tool for DB2 from Responsive Systems, and show you how to analyze and tune your system, and evaluate the payback. Converting I/O savings to elapsed time, dollar savings, and improved productivity. Performance Wizard is a built-in component of Buffer Pool Tool that applies tuning logic to your systems performance data, and provides pool threshold and sizing guidance, and object placement suggestions. Aside from the elapsed time and cpu savings from I/O elimination, the tuning process often highlights significant application performance problems. See the steps of analysis and tuning using the industry standard Buffer Pool Tool for DB2, learn how to analyze and tune your system, and evaluate the payback. Converting I/O savings to elapsed time, CPU saving, $ savings, and improved productivity. Buffer Pool Tool, as the industry standard, is the only product with proven accuracy, and - can predict the I/O rate per second.

EXP. LEVEL: Intermediate

OBJECTIVES:

Understand the important DB2 buffer pool performance metrics, thresholds, and tuning options. Rules of thumb, and guidelines for thresholds & options ; vpseqt, dwqt, vdwqt, pagefix, lru, fifo

Learn how Buffer Pool Tool works, how it interfaces with DB2, and how it predicts the IO effects of pool tuning changes; both pool sizes, and moving objects into other or new pools.

Performance Wizard component - how it works, the information it provides, and how it speeds your analysis and tuning process

Using data from several large production systems, understand how the analysis and prediction capabilities provided solid and measurable performance improvements

Converting performance improvements to monetary cost savings - How to sell your management the benefits of tuning.



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.