SQL2310N The utility could not generate statistics. Error "-668" was returned.

[kavin]

Hi,

I am getting the error when i runstats for a table SQL2310N The
utility could not generate statistics. Error "-668" was returned.
Also The tablespace is 100% full. Is this the reason why runstats is
getting failed? if not how can i analyse the reason why the runstats
got failed.

Thanks
Kavi.

[Ian]

The -668 error is SQL0668N: "Operation not allowed for reason code
*reason-code* on table *table-name*."

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.messages.sql.doc/doc/msql00668n.html

You may have received more information (i.e. the reason code) that you
can use to figure out why your table is inaccessible. If you didn't,
try selecting data from the table and you should get the SQL0668N
error message with more detail.

Most commonly you'll see reason code 1 (table is in set integrity
pending) or reason code 3 (table is in load pending state).

[jedwar...@gmail.com]

I was having the same trouble.
Another way to get the reason code on DB2 9.5 LUW is to try to reorg the indexes.