Articles & Content


DB2 Performance, the Basics... and a Bit, To a Lot More (B09)

Topic: DB2 for z/OS

Subtopic: 2007

DATE: 2007-11-7 (11:00 - 12:00)
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. We will illustrate the basic thresholds and data that provide quick insights about problems both at the application level, and the system level. We will show Charts and graphs that illustrate the surprising CPU and dollar costs of sequential prefetch and IOs.

EXP. LEVEL: Beginner,Intermediate


Sources of data, DB2 and others

Obtaining data, understanding what you have

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

Using and applying the data, relating it to, and estimating performance improvements

Performance measurements, examples, and improvements from the real world

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.