Articles & Content


DB2 System Performance, Peeling the Onion (A06)

Topic: 2009 NA

Subtopic: DB2 for z/OS

DATE: 2009-5-13 (11:00 AM - 12:00 PM)
SPEAKERS: Joel Goldstein (Responsive Systems Company)

This presentation addresses the approaches, values, thresholds, triggers, and relationships ofperformance data analysis. Performance monitoring, analysis, and tuning should be a pro-active and continuous process; however, this often gets neglected because people are too busywith other work, or they are not sure what data is really important. Certain thresholds anddata provide quick insights about problems both at the application level, and the system level. As you peel back the layers of performance information, each area that we improve has animpact upon other areas. These performance layers are a lot like the layers of an onion. Westart from the obvious outside metrics, and work our way in to lower levels of performancemeasurements and tuning opportunities.

EXP. LEVEL: Intermediate


Sources of data

Key Performance Thresholds and Indicators - There are many inter-relationships

Rules of thumb - what is good, what is bad, what is gray...

Applying the metrics of your system

The path to better performance is not always obvious

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.