Version
All versions
Explanation
Unable to execute DDL on replication tables.
Cause
This error is due to DDL restrictions on replication tables.
Action
Set REPLICATION_ENABLE to 1.
Reference
It is not advisable to execute DDLs during replication. If the user wants to apply the REPLICATION_ENABLE property, we recommend that it is done only in the development stage and for the sake of convenience.
<How to execute DDLs in older versions>
The ALTER COLUMN statement is not supported for ALTIBASE HDB 5.3.3 or below and under certain circumstances, it is impossible to execute DDL statements. For example, a DDL statement that includes a table column position change or a DDL statement that is currently unsupported by Altibase cannot be executed as it is. In such cases, the user needs to back up the data of the replication target table before executing the DDL statement and recover the data afterwards.
In general, the user can take the following steps:
1. Stop services.
2. Check that the replication gap between the target nodes is 0.
3. Stop replication between the target nodes.
4. Remove the table from the replication table list.
5. Back up the table data using iLoader.
6. Execute the DDL statement on the table.
7. Recover the table data using iLoader.
8. Add the table back to the replication table list.
9. Start replication between the target nodes.
Since data backup and recovery consume time, the user is recommended to estimate how long services will be stopped before performing the above operations.
Further information about iLoader options is available in the iLoader User's Manual.