Articles & Content
Topic: 2010 NA
Subtopic: Cross Platform DB2 for z/OS & LUW
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
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.
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.