KFAA31555-E
The UNARCHIVABLE option cannot be specified in ALTER TABLE statement, because aa....aa. (M+J+O)
The archivable multi-chunk table could not be changed to a regular multi-chunk table because an error occurred in the ALTER TABLE statement. <SQLSTATE: 42IBF>
- aa....aa: Cause of the error
-
-
the table has an archived chunk
The archivable multi-chunk table that contains an archived chunk is specified in the ALTER TABLE statement.
-
the table is not an archivable multi-chunk table
A table that is not an archivable multi-chunk table is specified in the ALTER TABLE statement.
-
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
-
If aa....aa is the table has an archived chunk
Execute the adbunarchivechunk command to release the chunk from the archived state. Then, execute the ALTER TABLE statement.
Note that if there is a deletion-pending chunk in the archived state, delete the target chunk by using the PURGE CHUNK statement, and then execute the ALTER TABLE statement.
-
If aa....aa is the table is not an archivable multi-chunk table
Confirm that the table name specified in the ALTER TABLE statement is correct.
-