1 The table is in the Set Integrity Pending No Access 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 the Set Integrity Pending No Access state may also receive this error if a dependent table is in the Set Integrity Pending No Access state.
2 The table is in the No Data Movement state. When in this state, operations that cause data movement are disallowed. Data movement operations include REDISTRIBUTE, update of database partitioning key, update of multi-dimensional clustering key, update of range clustering key, update of data partitioning key and REORG TABLE.
3 The table is in the Load Pending state. A previous LOAD attempt on this table resulted in failure. No access to the table is allowed until the LOAD operation is restarted or terminated.
4 The table is the Read Access state. This state can occur during on-line LOAD processing (LOAD INSERT with the READ ACCESS
option), or after an on-line LOAD operation, but before all constraints have been validated in the newly appended portion
of the table using the SET INTEGRITY statement. No update activity is allowed on this table.
5 The table is in the Load In Progress state. The LOAD utility is currently operating on this table, no access is allowed until
the LOAD is finished.
6 Materialized query tables that reference a nickname cannot be refreshed in ESE.
7 The table is in the reorg pending state. This can occur after an ALTER TABLE statement containing a REORG-recommended
operation.
8 The table is in the alter pending state. This can occur when using the table in the same unit of work as an ALTER TABLE
statement containing a REORG-recommended operation.
9 The table is in Redistribute Pending state. The REDISTRIBUTE utility is not completed on this table, no access is allowed
until the REDISTRIBUTE is finished.
