This section goes through some of the common Q replication source table maintenance tasks.
The following list summarizes the source table maintenance tasks and whether they are allowed in a Q replication scenario. Can we:
Add a column to a Q subscription?: Yes, see the To add a column to a Q subscription section.
Remove a column from a replicated source table?: No, see the To remove a column from a replicated source table section.
Alter the column attributes of a replicated source table?: No, see the To alter the column attributes of a replicated source table section.
Perform an online
REORG
on the source table?: Yes, see the Performing a reorganization on the source table section.Perform a classic reorganization on the source table?: No, see the Performing a reorganization on the source table section.
Perform a
RUNSTATS
on the source table?: Yes, see the Collecting statistics on the source table section.Perform a
LOAD
operation?: It is possible, see the Performing...