Articles & Content
Topic: 2007 NA
Subtopic: DB2 for z/OS
DATE: 2007-5-7 (01:40 PM - 02:40 PM)
SPEAKERS: Tom Moulder (TREX Associates, Inc.)
Ever wondered about DB2 performance? Why some statements work well and not others? This presentation will explain the difference between DB2 without help and DB2 with help. The particular help that will be discussed is the ability of DB2 to collect statistics concerning data content that can be used to improve performance. Don't let the title scare you. At no time during the presentation will I ever use anything more that addition, subtraction, multiplication and division. The longest calculation is of four values. Simple Math can be used to unlock the secrets of DB2.
EXP. LEVEL: Intermediate,Advanced
The attendee will learn how the various inputs to the Optimizer determine the selected access path
The attendee will learn what distribution statistics are and how they influence access path selection in the DB2 Optimizer
The attendee will learn what coorelation statistics are and how they influence access path selection in the DB2 Optimizer
The attendee will learn of changes in the DB2 Optimizer in Version 8 and how these changes can be exploited to improve performance during Version migration
The attendee will learn how to capture distribution and coorelation statistics and update the catalog so that the DB2 Optimizer can use these values to improve access paths
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.