Articles & Content

Archives

MDT, Measurement Driven Tuning (E16)

Topic: DB2 for z/OS

Subtopic: 2008



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?



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.