We are having UDB Ver 7.2 on Unix server. Our database is around 20GB. We have around 70 user tables in the database. We use to do runstats daily with the help of a program. Program kicks of automatically. Program automaticall generates the runstats script for all the tables and it runs against the database.
Script generates runstats scirpt like this..
"RUNSTATS ON TABLE <table name> WITH DISTRIBUTION AND DETAILED INDEXES ALL"
Some days it does the runstats without any problem... But some days we use to get the following error...
"SQL2314W SOME STATISTICS ARE IN AN INCONSISTENT STATE. THE NEWLY COLLECTED TABLE STATISTICS ARE INCONSISTENT WITH THE EXISTING INDEX STATISTICS."
The above erros occurs in a random fashion ... It occurs for different tables each time...
Can any one explain why it happens like this? More over it will be helpful if anyone can give solution for this