Try the volatile on the table and see what the db2advis says. You can also
look at your join to make sure the keys are in the right order.






"paul"
<db2udbdba-ezmlms
hield-x44564791.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
05/23/2006 10:55
AM Subject
Fwd: Re: Index usage










Dan,

Thank you for the fast reply. Runstats are run daily, optimization is 5
and I am testing this on a low usage DB, although it is behaving the same
here as production and prod is much higher usage.

Ideas?

> To: "LazyDBA Discussion" <[Email address protected]
> From: "DANIEL CALLAHAN " <db2udbdba-ezmlmshield-x18067545.[Email address
protected]
> Date: Tue, 23 May 2006 10:42:19 -0400
> Subject: Re: Index usage
>
>
>
>
>
> Can we assume you have done runstats?
> and maybe set the optimization to at least 3
> and make the table volatile, if the activity is high?
>
>
>
>
>
>

> "paul"

> <db2udbdba-ezmlms

> hield-x48947348.x
To
> [Email Address Removed] "LazyDBA Discussion"

> a.com> <[Email address protected]

>
cc
> 05/23/2006 10:31

> AM
Subject
> Index usage

>

>

>

>

>

>

>
>
>
>
> Hello all,
>
> Have a rather strange occerence here that is perplexing me and am in need
> of a little guidance. Running AIX 5.3 UDB "DB2 v8.1.1.80", "s041221",
> "U800400", and FixPak "8". I have many occurrences of specifying a join
on
> two tables on an index, but the optimizer is determined to do a table
scan.
> I would like to avoid optimizer hints as they could bite me in the
> preverbial rear down the road. I did find where I had the DFT_DEGREE set
> to one, shich of course is no paralellism at all. Are there any other DB
> parameters that you are aware of that I should be looking at before going
> after fix packs?
>
> TIA
>
> PL
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page