Articles & Content


Access Path Stability for Dynamic Queries (B11)

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.