The following error are observed when running analyze on a config:
sp_ctrl (alvsupu15:5438)> analyze config config1
A configuration file is currently in replication or analysis
Cannot analyze a config when an active config exists
In our case when the analyze is issued, there is already an active config file (even if it is different from the config file that we wish to analyze) hence it fails. Here is the "list config" command that shows another config file that is active:
If wishing to run analyze, first deactivate or abort the active config file and then run analyze prior to activating the original config. However, if activating the config requires a downtime and if this is a production environment, you may want to find a window of opportunity when you can stop replication for some time to carry this out. Remember that you need to run it when the database is active so as to collect useful statistics. Moreover you need to find subsequent database downtime for activating a config to start replication afresh.
The command is usually run prior to setting up first time replication for the purpose of analyzing the transaction mix in an active database.
There is yet another way to run analyze in an environment where an active config exists. One can create a second instance of SharePlex and then run analyze on that second instance. For details on creating second instance of SharePlex on a server which also has an existing instance, please refer to SharePlex Administrator Guide Chapter titled "Run multiple instances of SharePlex".
