Thanks, Pierre&Haider,
Yes, I used LIKE STATISTICS when I did the runstats. And that is enough
thing we should do. I spent a couple of days try to figure out what the
problems are and finally gave up.
We support more than one db2 server and more than one physical database.
They all used the same way to migrate to Version8.1. I found out I failed to
collect sub-element statistics only on one of the database. I have no clue
what kind of things hide behind this database. Especially when all the other
statistics information I collected are just like what I expected.
Regards,
FRX
"Pierre Saint-Jacques" <se*****@attglobal.net> wrote in message
news:41**************@attglobal.net...
Isn't there a variable that needs to be set for thLIKE statistics to be
collected.
Don't have mu docs available but...
HTH, Pierre.
Haider Rizvi wrote: "Fan Ruo Xin" <fa*****@sbcglobal.net> writes:
I ran the runstats and try to collect sub-element statistics, but for
somereason, the value of that two fields in syscat.columns is always -1.
Doesanyone have any idea?
What syntax did you use that didn't work?
Regards,
--
Pierre Saint-Jacques - Reply to: sescons at attglobal dot com
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.