Running multiple compare/repair sessions on a dedicated port simultaneously results in the following error:
sp_ctrl (irvsupu07:4048)> compare table splex32.essai to splex32.essai target irvsupu08@o.olga817 port 7777
sp_ctrl (irvsupu07:4048)> compare table splex32.demo_src to splex32.demo_src target irvsupu08@o.olga817 port 7777
Socket creation failed with error 125: Address already in use.
There is only one open port for compare and repair to go through the firewall.
RESOLUTION 1:
When there is only one open port for compare and repair to go through the firewall, only run one compare/repair session at a time.
RESOLUTION 2:
Open a different port on firewall, and run the second compare/repair using the new port#.
RESOLUTION 3:
In order to run compare on multiple tables using the port option, one needs to create a dummy config file containing such tables and use compare config. This way only one compare process is launched for all such tables and there is no interference resulting in Socket creation failed with error 125: Address already in use. Various tables are compared using the threads of the main compare process. See SOL51005 for details on the processes created by compare table vis-à-vis compare config.
