Articles & Content

Archives

Optimizing DB2...Through Statistics Trace (Part 1 of 2) (B05)

Topic: DB2 for z/OS

Subtopic: 2008



DATE: 2008-5-20 (09:15 AM - 10:15 AM)
SPEAKERS: John Campbell (IBM DB2 for z/OS Development)

This presentation will go into some detail about how to use the DB2 Statistics Trace, as formatted by Omegamon/DB2PE, introducing and discussing some thirty rules used by the presenter over many years to: evaluate DB2 system performance, filter for bad coniditinos and recommend actions.

EXP. LEVEL: Intermediate

OBJECTIVES:

Analysis and tuning of CPU

Analysis and tuning bufferpool

Analysis and tuning EDM pool

Analysis and tuning active logging

Analysis and tuning sort



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.