Articles & Content

Archives

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

Topic: 2008 EU

Subtopic: DB2 for z/OS



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



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.