Overview of copy/append process (4259035)

The copy/append command initiates a process to synchronize individual tables between individual hosts.

The following is the sequence of events that illustrates simple synchronization process activity:

1. The launcher process must be running on the target system(s) prior to executing the copy/append command. To start the launcher process the user must execute the following command on each of the target systems:

1. When the copy/append command is issued from a sp_ctrl session the sp_cnc spawns sp_sync_svr on the source system.
2. The sp_sync_svr connects to the target system and starts the sp_sync_clnt on the target system.
3. The sp_sync_svr sends the sp_syn_clnt a table list to verify information on the target table. a) If the object is being copied (versus an append) the target table is truncated.
4. For each object under copy the sp_sync_svr starts up an Oracle export process.
5. If the object under copy is in replication sp_sync_svr must wait for sp_sync_clnt to indicate that the Post process is ready.
6. The sp_sync_clnt process starts an Oracle import process for each of the objects that the sp_sync_svrprocess opened an Oracle export process f
7. The sp_sync_svr process transfers data to the sp_sync_clnt process until the copy is complete.
8. If the object under copy is in replication the Post process re-initiates and resumes it’s posting activities.
9. Launcher process can be stopped once all copy/append jobs are finished.