Supported DDL operations in Db2 Warehouse
Db2 Warehouse replication supports the following Data Definition Language (DDL) changes:
| DDL | Table type | Comment |
|---|---|---|
| ALTER TABLE ADD COLUMN | Row and column | |
| ALTER TABLE ALTER COLUMN | Row only | Not applicable for column. See the Db2® restrictions for altering columns in column-organized tables. |
| RENAME COLUMN | Row only | |
| ALTER PRIMARY KEY | Row only | For column-organized tables, stop replication for the table, manually make the DDL changes, and restart replication. This change initiates a full reload of the target table. |
| ATTACH/DETACH | Tolerated for row only; not applicable for column | Attach and detach of table partitions are not replicated. You must perform the operation on
both the source and target. There is no impact on replication. Column-organized tables cannot be
range partitioned. Changes to new partitions are replicated, but the actual attach operation is not replicated. Because of this, if you do not attach the same partition on the target table the row ends up in a different partition at the target. If you want partitioning to be identical at both the source and target, you can stop replication when making the changes, or make the changes first at the target and then at the source while replication is running. |
Replication also supports TRUNCATE TABLE operations for both row- and column-organized tables.