Articles & Content

Archives

MDT, Measurement Driven Tuning (E16)

Topic: 2008 EU

Subtopic: DB2 for z/OS



DATE: 2008-10-16 (11:45 - 12:45)
SPEAKERS: Jan Henderyckx (BRAINWARE )

We all know that the best point of starting tuning is the design phase. In practice the DBA or performance responsible is only called in when the house is on fire. This presentation looks at an approach to use performance measurements to determine where and how to tune. It also covers some blind spots in the performance info due to new features in DB2.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

Finding inefficient SQL through accounting tracing.

How efficient is my commit frequency and how can I gain by changing it?

How to know a badly tuned subsystem is the cause of the problem?

What should your overall tuning methodology be?

What can I get from non-DB2 tooling?



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.