Hi All,

I am running Db2 9.5 FP 5 on RedHat 5.3. I run runstats once every week and i was looking at the stats_time column in the syscat.tables but the timestamp is from August 2010. Why is the stats_time showing an old timestamp when I am running runstats every week?

Thanks

Are you sure that runstats runs to completion without an error? What is the command you are using for runstats?

Andy

I don't see any error messages in my output file. The command I am using for runstats is:

runstats on table tableschema.tablename with distribution and indexes all

Actually I did get this warning, not so much an error:

SQL2314W Some statistics are in an inconsistent state. The newly collected
"TABLE" statistics are inconsistent with the existing "INDEX" statistics.
SQLSTATE=01650

This system does get a lot of updates so maybe thats why I sometimes see that warning message. But i still don't understand the reason why the stats_time timestamp is way off.

I do not know either. Do all of the tables have the problem, or are some correct?

Andy