| |
- Causa
- A CREATE/ALTER ON OBJECT object-name HAS PLACED OBJECT IN utility PENDING
The identified object is in one of the following states:
- 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 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.
- Ação do sistema
- The object was placed in the indicated pending status.
- Resposta ao Desenvolvedor
-
The following actions may be taken:
- For REBUILD pending on an index, use the REBUILD INDEX utility to rebuild the index and remove the REBUILD
pending status.
- For REORG pending on a table space partition, perform the following steps:
- Issue a DISPLAY DATABASE command for the table space to identify which partitions are in REORG pending.
- Run the REORG utility on the partitions that are in REORG pending.
- For REORG pending on a table space, run the REORG utility on the table space.
SQLSTATE: 01566
|
| |
