How to use copy (or append) to sync tables in a broadcasting replication environment. (4330712)

The copy command will sync a target table in a normal reporting environment where there is only one target. When there are multiple targets involved, as in case of a broadcasting replication topology, then some additional steps may need to be incurred to sync the target tables across multiple targets. The solution delves on this issue.

General information.

In a simple reporting environment involving single target, the copy command can be issued without any reference to the target (though specifying the target will not hurt).In its simplest form, the syntax of the copy only contains the owner and name of the replicating source table:

{SOURCE_OWNER.EN}.{SOURCE_TABLE.EN}

The command will be able to determine the target route from the active config file. If multiple targets are involved, as in broadcasting replication, then one may need to issue copy separately for all targets one source and target pair at a time. For example, if there are two targets involved, then a copy can be issued for synchronizing the first target table and then a second copy can be issued (after the first copy finishes) for the second target table.
The syntax of the copy command when specifying the target routing info is:

{SOURCE_OWNER.EN}.{SOURCE_TABLE.EN} [at {TARGET_HOST.EN}.[{TARGET_SID.EN}]]