we have db2v9.7 fp5 running on aix machine. Its a partition database ,which is used for reporting purpose.i could see the difference in card value and total no.of rows in table.even the stats time is reflecting as 5 days back.
I have done the runstats using distributed shrlevel option.
The interesting thing is ,even after runstats i could see the card value is still showing the old count,but i could see the stats time got changed.can you please let me know what might the reason ,why still the card value is not getting updted after runstats unlike stats time.
This topic has been locked.
1 reply Latest Post - 2013-03-20T22:31:53Z by krmilligan
Pinned topic Runstats is not getting updated.
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-03-20T22:31:53Z at 2013-03-20T22:31:53Z by krmilligan
krmilligan 120000MDWP335 PostsACCEPTED ANSWER
Re: Runstats is not getting updated.2013-03-20T22:31:53Z in response to DF5V_krishna_BissaDB2 for i doesn't have a RUNSTATS command because it automatically collects statistics.
You need to post your question in the DB2 for LUW forum: http://www.ibm.com/developerworks/forums/forum.jspa?forumID=842