-
Title
Are sync/ copy parameters live? -
Description
When querying the current settings of the sync/ copy parameters by issuing the command list param all sync, it appears that the parameters are set live as seen in the sample output below:
sp_ctrl (serverA:2100)> list param all syncSync parameters:
Parameter Name Actual Value Units Set At
------------------------------ -------------------- ------- ---------------
SP_OSY_COMPRESSION 6 Live
SP_OSY_DEBUG 0x00000000 bitflag Live
SP_OSY_EXP_BUFFER_SIZE 1024 kbytes Live
SP_OSY_IMP_BUFFER_SIZE 1024 kbytes Live
SP_OSY_LOCK_ALL 0 Live
SP_OSY_LOCK_TIMEOUT 2 Seconds Live
SP_OSY_PORT 2501 Live
SP_OSY_POST_TIMEOUT 1800 Seconds Live
SP_OSY_TCP_TIMEOUT 60 Seconds Live
SP_OSY_THREADS 5 Thread LiveThis solution delves on interpretation of what live means in the context of copy command.
-
Cause
General information.
-
Resolution
The parameters are live in the sense that any changes made to the parameters will apply to the future copy commands issued from the Shareplex instance. It will not affect the currently running copy commands. In this respect the copy/sync feature differs from other Shareplex commands where live means that the parameter change takes effect immediately for the process in question.
The interpretation assumes importance in scenario where a debug needs to be set for a problem copy process. There is no way the debug will be set live, so one may need to wait for the problem copy process to finish (or error out) or terminate it manually prior to setting debug and starting a new copy.