Articles & Content


DB2 System Performance, the Basics... and a bit, to a lot more (A03)

Topic: 2008 NA

Subtopic: DB2 for z/OS

DATE: 2008-5-19 (01:30 PM - 02:30 PM)
SPEAKERS: Joel Goldstein (Responsive Systems Company)

This presentation addresses the approaches, values, thresholds, triggers, and relationships of performance data analysis. Performance monitoring, analysis, and tuning should be a pro- active and continuous process; however, this often gets neglected because people are too busy with other work, or they are not sure what data is really important and which data quickly shows that there are problems - when nobody is complaining. Some basic thresholds and data provide quick insights about problems both at the application level, and the system level. Charts and graphs illustrate the surprising CPU and dollar costs of sequential prefetch and IOs.

EXP. LEVEL: Beginner,Intermediate,Advanced


Sources of data

Key Performance Thresholds and Indicators - Do you have a problem?

Rules of thumb - what is good, and what is not

Using and applying the data

Performance impacts and improvements from the real world

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.