Did you rebind all the db2cli.lst packages ?

Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]




"ighiurea "
<db2udbdba-ezmlms
hield-x47627343.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
06/14/2004 01:50
PM Subject
runstats in DB2










Hi there,

I have a table with over 24 mil rows , I run stats 2 months ago, last
weeek I aplied last fIX pack forDB2UDB, I run a quesry against the table
the performance were worst 30 minutes for a qury that normaly takes 30
sec.
I run explain plan the quesry was not using the MDC index, today I
runstats and same query took 30 sec ...

is DB2 still not using the old runstats if data was not changed since
than ??????


Isabella




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]



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