Articles & Content
Topic: 2009 NA
Subtopic: DB2 for z/OS
DATE: 2009-5-14 (02:45 PM - 03:45 PM)
SPEAKERS: Thomas Baumann (Swiss Mobiliar)
To rebind or not after a new DB2 release, a maintenance upgrade, or after running RUNSTATS has been a crucial question for a long time. After the implementation of optimizer hints, the REOPT bind option, and access plan management, things became easier for static SQL queries. But for dynamic queries, it is still at the customer's responsibility to ensure access path stability. This presentation shows methods for your dynamic workload to avoid access path regression and to correct unexplainable access paths, such that you don't dread your next RUNSTATS run, application or DB2 release, or your next maintenance upgrade.
EXP. LEVEL: Beginner,Intermediate,Advanced
Reasons of access path instability
Access path fallback for static queries
Limiting exposure to instability for dynamic queries
Access path corrections for dynamic queries
Query performance management as a continuous process
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.