Articles & Content


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

Topic: 2008 NA

Subtopic: DB2 for z/OS

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


Analysis and tuning of CPU

Analysis and tuning bufferpool

Analysis and tuning EDM pool

Analysis and tuning active logging

Analysis and tuning sort

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.