Articles & Content

Archives

Tuning your System with the Buffer Pool Tool® and DIFF for DB2 (G02)

Topic: DB2 for z/OS

Subtopic: 2008



DATE: 2008-10-13 (13:30 - 14:30)
SPEAKERS: Joel Goldstein (Responsive Systems Company)

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 addresses 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.The tuning process often highlights significant application performance problems. DIFF solves the most difficult analysis issue, of comparing workloads to highlight simulariies and differences. Making sure your apple is being compared to an apple.

EXP. LEVEL: Intermediate

OBJECTIVES:

Provide the ability to predict the effect of buffer pool changes

Provide a reliable technique for grouping objects into multiple pools

Show the performance projections, and let you make the intelligent decisions based upon your resources

Learn how things work - your system, your buffer pools, & your application object usage and access

Optimize system and application performance, and memory utilization



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.