Articles & Content

Archives

Who Stole My Favorite Scan and Access Path ? (G02)

Topic: DB2 for z/OS

Subtopic: 2008



DATE: 2008-5-19 (11:00 AM - 12:00 PM)
SPEAKERS: Steen Rasmussen (CA)

During the lifetime of DB2, Explain and Access Path prediction have gone through a huge evolution. This presentation will look at some of the major changes over time and how the Optimizer has grown from a toddler to a much more robust piece of art. Performance is a major concern for all DB2 sites, so we will look into different methods to predict performance before doing Bind and Rebind, which potential corrective actions to take and how to prepare yourself to find the reason(s) for a better or worse access path when "something slipped through".

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

Explain evolution over the years - are you aware of all the new stuff.

Optimizer resources for deciding "the correct" access path and how the user can influence these decisions.

Which methods can be used to make corrective actions to application SQL and how to predict access path when moved to the next stage/level.

Explain versioning and the information needed in order to find the reason(s) for a access path change or performance degradation/improvement.

A method to compare access path and performance improvement/degradation (the cost of executing the SQL statement) and a potential Rebind.



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.