DATE: 2009-10-6 (08:30 - 09:30)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,AdvancedOBJECTIVES:Reasons of access path instabilityAccess path fallback for static queriesLimiting exposure to instability for dynamic queriesAccess path corrections for dynamic queriesQuery performance management as a continuous process