Articles & Content

Archives

DB2 for z/OS System Performance Basics - DB2 Statistics Review (A06)

Topic: 2007 NA

Subtopic: DB2 for z/OS



DATE: 2007-5-8 (10:40 AM - 11:40 AM)
SPEAKERS: Randy Ebersole (IBM DB2 for z/OS Lab Services)

There is a wealth of information available from DB2 statistics. In this presentation we will discuss DB2 statistics and how to interpret these statistics based on various production scenarios.We’ll focus on what the many statistics mean and steps to take on how to address the issues to improve DB2 performance. Our main objective in this session is to improve the understanding of the DB2 Statistics information and allow the attendee to increase the ability to exploit this information in their specific DB2 environments.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

How DB2 provides DB2 Statistics

Five primary areas to focus on when reviewing DB2 Statistics information

How to learn about their specific environment and take steps to improve DB2 system and application performance

Interpretation of DB2 workload characteristics

What new information is available in DB2 Statistics



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.