KFAA31551-E
aa....aa in ARCHIVABLE clause must not be specified. (M+J+O)
The chunk-archive specification in the ALTER TABLE statement is invalid. Neither IN DB-area-name nor RANGEINDEXNAME can be specified in the chunk-archive specification in the following case: <SQLSTATE: 42IBB>
-
A range index has already been specified on the column specified as an archive range column.
- aa....aa: Invalid part
-
-
The name of the DB area for the index
The specified name of the DB area that stores the range index (IN DB-area-name) is invalid.
-
The index identifier
The specification of RANGEINDEXNAME in the chunk-archive specification is invalid.
-
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
-
If aa....aa is The name of the DB area for the index
Delete the specification of IN DB-area-name from the chunk-archive specification.
-
If aa....aa is The index identifier
Delete the specification of RANGEINDEXNAME from the chunk-archive specification.
-