There is an active config file with multiple export queues and data is being replicated to multiple sources. The current configuration does not use secure shell tunnel, just port 2100 for sp_cop. I would like to add a new target and have the replication route (to the new target) go through the stunnel. Shareplex port will still be 2100, and the stunnel port will be 2300.
I tried to set below two parameters for the new target BEFORE activating new config and activation failed with "Check line 7, for bad routing spec".
set param SP_XPT_PORT_OVERRIDE to new_host_name 2300
set param SP_XPT_USE_LOCALHOST to new_host_name 1
SP_XPT_PORT_OVERRIDE and SP_XPT_USE_LOCALHOST parameters cannot be set before activation for the new target, since Shareplex is not aware of the new_host_name. These two parameters have to be set after activation is done.
1. Stop all export queues
2. Activate config
Sp_ctrl> set param SP_XPT_PORT_OVERRIDE to new_host_name 2300
Sp_ctrl> Set param SP_XPT_USE_LOCALHOST to new_host_name 1
3. Start export