| |
- Causa
- THE ALTER INDEX CANNOT BE EXECUTED, REASON reason.
The ALTER INDEX statement cannot be executed for one of the following reasons:
- 1 Alter to type 1 index is not allowed for the index whose associated table space has a LOCKSIZE specification of ROW.
- 2 Alter to type 1 index is not allowed for the index defined with UNIQUE WHERE NOT NULL.
- 3 Alter to type 1 index is not allowed for the index whose associated table space has been defined as a LARGE table space.
- 4 Alter to type 1 index is not allowed for an index on an ASCII table.
- 5 Alter PIECESIZE is not allowed for a partitioning index.
- 6 Alter PIECESIZE 4G is not allowed for non-partitioned indexes on a non-LARGE table.
- 11 Alter VALUES is not allowed for an index on a partitioned base table with LOB columns.
- Ação do sistema
- The ALTER INDEX statement is not executed.
- Resposta ao Desenvolvedor
- Correct the error according to the given reason and execute the statement again.
SQLSTATE: 56090
© Copyright IBM Corp.
|
| |