How to change an active config.
The procedure for adding or removing objects from an active replication scheme is as follows:
1. In sp_ctrl, copy the active config:
sp_ctrl> copy config active_config_name to new_config_name
2. Edit the new config in sp_ctrl and comment out the lines containing objects to be removed or just delete the lines from
the new config or add the new table entries:
sp_ctrl> edit config new_config_name
save and exit to save the changes to the new file.
3. Activate the config file:
sp_ctrl> activate config new_config_name
If new objects were added to the new config file, there tables will be locked and analyzed. Once the config file is successfully activated, the old config file will be deactivated. If the new activation fails for some reason, the old activation is retained. The activity of the activation program will be registered in the event_log.
In earlier version of shareplex "edit config" on an active config file was allowed but not recommended because if the current config file is modified and activated and an error occurs, (ie: user in a table and shareplex can't lock it, tablespace is full, etc...), then the entire activation would fail, including the tables that were previously in activation. By copying the config file to a new file and activating the copy, then if anything goes wrong, the previous config file will still be active.
In latter versions of shareplex "edit config" command on an active config file was disabled.
Attempting to activate a currently active config file results in the following error:
sp_ctrl> edit config config_file_name
Edit config file is not allowed for an active config file
See Chapter titled “Preventing and Solving Replication Problems” in Shareplex Reference Guide for further details.