When you activate a config, it takes some time for the sp_ctrl to return the control back to the issuer. This time typically depends on the # of tables activated and can also depend on whether some tables are currently locked in exclusive mode by users, among others. This article delves on whether it is possible to cancel out the activation process which is in progress by Ctrl-C, etc, if needed.
General information.
Once the command “activate config <config_file>” is issued, the SharePlex process sp_tconf acts behind the scene to carry out the task of activating the tables that are part of the config file. The control is not passed back to the user till the activation finishes. Even if the user decides to cancel out the activation (by Ctrl-C, for example), the sp_ctrl prompt comes back but behind the scene the activation process still runs and finishes the task.
The event_log and activation logs (oconf and *rmp* logs) would have logging of such tasks. The only reason the sp_ctrl prompt is not returned to the user is to display the outcome of the activation when it finishes. So Ctrl-C or any other means like closing sp_ctrl window will not abort an ongoing activation process.
There are no simple ways to cancel it other than to identify the activation process via ps -ef and grep for conf, then kill that activation process by the flag "kill -9" (assuming that this is a UNIX environment). Another recommended approach is to wait it out and let it finish. It is always possible to abort or deactivate an active config at a later time if needed.
If on Windows, kill the activation process via Task Manager. The activation process is named sp_tconf.exe in Windows.
© ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center