Db2 SQL0668N error for reason nr. 8 retrived

See more:

errors

DB2

Hi,

Hi have DB2 9.7.200.358/Windows 7 Ult SP1. After an Alter Table Add Column command, the DB engine retrieves the error in the object for any select into that table. I restarted the DB, I restarted windows, but the issue remains.

I noted this:

SELECT * FROM SYSIBMADM.ADMINTABINFO where TabName like 'MF_S%'

(retrieving two tables)
The difference between them the indict table is that have INDEXES_REQUIRE_REBUILD setted as 'Y'.

I droped all indexes and reference keys, but the issue and the flag remain.

I tried also this:

REORG TABLE <MyTable> ALLOW NO ACCESS;
REORG INDEXES ALL FOR TABLE <MyTable> ALLOW NO ACCESS;
RUNSTATS ON TABLE <MyTable> ON ALL COLUMNS WITH DISTRIBUTION ON ALL COLUMNS AND DETAILED INDEXES ALL;

The first statement runs well. The second and the third return the same error (even if there is no index).

What I have to do?

[News:]
Hi,

I think the problem is deeper than i thought. In fact I made a database bakcup and I restored it in a different PC, the problem has remained.

Lucio