Articles & Content

Archives

Why does my Access Path Keep Changing? (A09)

Topic: 2005 NA

Subtopic: DB2 for z/OS



DATE: 2005-05-24 (03:30 PM - 04:40 PM)
SPEAKERS: Jorg Lueke (eFunds)

In the vast majority of cases the Optimizer is our friend. Once in a while though, it seems to curse us switching back and forth between two paths with each bind. This presentation will discuss the cases where we have seen this behavior and offer several different solutions to taming those borderline cases that can make our lives difficult.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Explain This - A Quick Review

When things go wrong

Helping DB2: Runstats and FudgeStats

Can you take a Hint?

Conclusions



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.