Can SharePlex replication be configured to have different port numbers for source and target?
It is possible to configure SharePlex to have different port numbers for source and target. There are two common scenarios where this may need to be implemented:
A. If there is currently a replication running from source to target having identical port numbers which is the default behavior and there is a need to change the target port number. Supposing that port 2100 is currently used for replication and one wants to change the target port to 2200. The following are the steps involved:
Shutdown SharePlex on target.
Change the values for the environment variables SP_COP_TPORT and SP_COP_UPORT so that they now point to 2200 (the new port number) instead of 2100 (the old port number). If SharePlex is started using a script, then the script will need to be amended to acquire the value of 2200 for these two environment variables. If the values for these variables is gathered from the paramdb file, then the entries for these parameters in the paramdb file needs to be edited to make it 2200.
On source sp_ctrl, set the value of the Export parameter SP_XPT_PORT_OVERRIDE to 2200 and bounce Export:
Source:
sp_ctrl>set param SP_XPT_PORT_OVERRIDE 2200
sp_ctrl>stop export
sp_ctrl>start export
Restart SharePlex on target
From now on the replication will use port # 2100 on source and will use port # 2200 on target.
B. If configuring a brand new replication to use different port numbers across source and target (say 2100 and 2200 respectively):
Install SharePlex on source and target but specify a value of 2100 on source and 2200 on target for both SP_COP_TPORT and SP_COP_UPORT.
Start SharePlex on source.
On source sp_ctrl, set the value of the Export parameter SP_XPT_PORT_OVERRIDE to 2200 and bounce Export:
Source:
sp_ctrl>set param SP_XPT_PORT_OVERRIDE 2200
sp_ctrl>stop export
sp_ctrl>start export
Start SharePlex on target
From now on the replication will use port # 2100 on source and will use port # 2200 on target.
In essence, the SP_XPT_PORT_OVERRIDE parameter is configured on the source SharePlex to specify the port number that Shareplex is using to listen on the target instance. By setting this parameter on the source instance it tells Shareplex that the SP_COP process is running on the specified port on the target instance and it should address the data packets to that specific port on the target instance.
There may be various reasons that require such type of configuration. One common reason is, firewall settings on target renders a particular port number unavailable thereby requiring a different port number to be used for SharePlex on target. Yet another common reason is, some application on target is already using the desired port #, thereby forcing the use of a different port # on target.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center