DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016

select * from CONTAINER

Operation not allowed for reason code "1" on table "DB2INST1.CONTAINER".. SQLCODE=-668, SQLSTATE=57016, DRIVER=4.7.89

症状:

Caused by: com.ibm.db2.jcc.b.SqlException: DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016, SQLERRMC=1;DB2INST1.CONTAINER, DRIVER=3.50.152

能帮忙看下吗

这个错误的原因

诊断:

由于该表处于检查暂挂状态时（Check Pending）。导致的原因是由于之前对该库做过一次数据迁移。使用的方式为db2move。

解决的办法是在表上做一次set integrity命令。且不检查其约束。

药方:

db2 => SET INTEGRITY FOR CONTAINER ALL IMMEDIATE UNCHECKED

DB20000I The SQL command completed successfully.

补充版:

db2 => reorg table DWDEV.TB_REPORT_TEMPLATE_RESULT_FIELD

SQL2216N SQL error "-668" occurred while reorganizing a database table or its

indexes.

db2 => SET INTEGRITY FOR DWDEV.TB_REPORT_TEMPLATE_RESULT_FIELD ALL IMMEDIATE UNCHECKED

DB20000I The SQL command completed successfully.

db2 => reorg table DWDEV.TB_REPORT_TEMPLATE_RESULT_FIELD

DB20000I The REORG command completed successfully.

ETL {Architect.Note}