Hi,
I dropped a not null column from a table.
After that i reorganized the table.
However, an update statement is giving error like
"(Reason "column number out of range".) SQLSTATE=58004"
So i ran stats on the table like
"RUNSTATS ON TABLE <SCHEMA.TABNAME>"
However, it gives error(warning) like
SQL2314W Some statistics are in an inconsistent state. The newly
collected
"TABLE" statistics are inconsistent with the existing "INDEX"
statistics.
SQLSTATE=01650
and i cannot find out how to run stats on indexes.
"RUNSTATS ON INDEX <INDEX_NAME. is not the syntax.
Further, is the problem coming due to this or their could be some
other problem.
Please help as it is urgent.
Thanks
Rahul