Articles & Content

Archives

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

Topic: 2007 EU

Subtopic: DB2 for z/OS



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

OBJECTIVES:

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



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.