+610 A CREATE/ALTER ON OBJECT object-name HAS PLACED OBJECT IN utility-name PENDING

Explanation

As the result of a CREATE or ALTER action on object-name, the object or a related object has been placed in a pending status.

object-name
The name of the object.
utility-name
The name of the utility.

The reason for this error depends on the utility-name value and the object type.

REBUILD pending for an index
  • The index is in REBUILD PENDING status because CREATE INDEX with DEFER was specified on a populated table.
  • The index is in REBUILD PENDING status because ALTER INDEX was used to add a nullable column to an EXCLUDE NULL KEYS index.
  • Start of changeAn index on table object-name is in REBUILD PENDING status because ALTER TABLE ALTER COLUMN was issued on table object-name. The column that was altered is part of the index, and the alter operation caused the index to be placed in REBUILD PENDING status. The table space that contains the table is placed in ADVISORY REORG PENDING status.End of change

The index is not generally available until the index is removed from the REBUILD pending state.

REORG pending for a table space partition
The table space is in REORG pending because ALTER INDEX was used to change the limit key values. The table space partition is not generally available until the REORG pending status is removed.
REORG pending for a table space
The table space is in REORG pending because ALTER TABLE was used to add an identity column to a populated table. The table space is not generally available until the REORG pending status is removed.
ADVISORY REORG pending for a table space
The table space is in ADVISORY REORG pending because an ALTER statement with pending definition changes has been issued. The table space is available, but the definition changes have not yet been applied.
ADVISORY REORG pending for an index
The index is in ADVISORY REORG pending because an ALTER statement with pending definition changes has been issued. The index is available, but the definition changes have not yet been applied.
REORG pending for a table
The table is in REORG pending because an ALTER statement with the INLINE LENGTH option reduced the maximum length for a LOB column.

System action

The object was placed in the indicated pending status.

Programmer response

The response depends on the utility-name value and the object type:

REBUILD pending for an index
Use the REBUILD INDEX utility to rebuild the index and remove the REBUILD pending status.
REORG pending for a table space partition
Perform the following steps:
  1. Issue a DISPLAY DATABASE command for the table space to identify which partitions are in REORG pending.
  2. Run the REORG utility on the partitions that are in REORG pending.
REORG pending for a table space
Run the REORG utility on the table space.
ADVISORY REORG pending for a table space
Run the REORG TABLESPACE utility with SHRLEVEL CHANGE or SHRLEVEL REFERENCE on the entire table space to materialize the pending definition changes.
ADVISORY REORG pending for an index
If pending definition changes do not exist for the table space, run the REORG INDEX utility with SHRLEVEL CHANGE or SHRLEVEL REFERENCE to materialize the pending definition changes for the index.

If pending definition changes exist for the table space, run the REORG TABLESPACE utility with SHRLEVEL CHANGE or SHRLEVEL REFERENCE to materialize the pending definition changes for the table space and associated indexes.

SQLSTATE

01566