DB2 database table Operation error SQL0668N Operation not allowed for reason code &

DB2 database table Operation error SQL0668N Operation not allowed for reason code "1" on table "XXXX ". SQLSTATE = 57016 solution The table is in Check Pending state. the integrity of the table is not enforced and the content of the table may be invalid. an operation on a parent table or an underlying table that is not in a check pending state may also receive this error if a dependent table is in a check pending state. execute t He set integrity statement with the immediate checked option on table-name to bring the table out of the Check Pending state. www.2cto.com For a user maintained materialized query table, execute the statement with the immediate unchecked option instead of the immediate checked option.: ERROR [57016] [IBM] [DB2/AIX64] SQL0668N Operation not allowed for reason code "1" on table "XXXX ". SQLSTATE = 57016 one or more rows may violate the data definition constraints. This table cannot be used for operations. If the slave table is in the check pending status, the operation on the parent table that is not in the check pending status may also receive this error. User response: Execute the set integrity statement with the immediate checked option, and ensure that the data meets all the constraints defined for the table or its tables. Set integrity for table name immediate checked