var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Stats_time showing old timestamp
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?
Are you sure that runstats runs to completion without an error? What is the command you are using for runstats?
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:
Originally Posted by
SQL2314W Some statistics are in an inconsistent state. The newly collected
"TABLE" statistics are inconsistent with the existing "INDEX" statistics.
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?