Articles & Content

Archives

Stabilizing Access Paths Across Rebind (A13)

Topic: 2008 EU

Subtopic: DB2 for z/OS



DATE: 2008-10-15 (17:30 - 18:30)
SPEAKERS: Terry Purcell (IBM Silicon Valley Lab)

Every new DB2 release, maintenance upgrade, or just running RUNSTATS brings the opportunity for changes in access paths after your next static SQL rebind or dynamic SQL execution. Even though the vast majority of SQL shows equal or better performance, we are still measured on the number of failures rather than successes. How can you safeguard yourself against access path regression so that you don't dread the upcoming migration/maintenance?

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Causes of access path instability

Limiting exposure to instability

Access Path Backup

REOPT

Hints



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!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.