When the command “copy using” is issued, it will sync multiple tables at a given time, depending on the # of tables in the config file upon which the command is operated. Ideally this is the optimum approach. At times customers may wish to serialize the copy process, meaning it should sync one table at a time. This could be due to resource issues, among others.
If the copy parameter SP_OSY_THREADS is set to 1 on both source and target and the command “copy using” is issued on a config file having more than one table, then the copy will be serialized. Meaning, will it sync one table at a time. So, to set the parameter to 1, do the following on source and target sp_ctrl:
Source:
sp_ctrl>set param SP_OSY_THREADS 1
Target:
sp_ctrl>set param SP_OSY_THREADS 1
From now on, if “copy using” is issued, it will only sync one table at a time and then move on to the next one. This may be useful if you wish to limit the resource usage by Copy.
