Completely remove Spectrum data source from CA Performance Management

Document ID : KB000092874
Last Modified Date : 24/04/2018
Show Technical Document Details
Introduction:
Completely remove Spectrum data source from CA Performance Management 
Instructions:

To completely remove a Spectrum data source from CAPM 

1. In the CAPM GUI go to Administration -> Data Sources -> Select the Spectrum data source and click the delete button. You will get a warning this warning however the data source can be removed and the steps below will allow the data source to be added to another CAPM system or back into the current CAPC system. Wait until the Spectrum data source is complete removed from CAPM.

2. Then on the Spectrum server perfoam the following steps depending on OS of the Spectrum OneClick server

On Windows Spectrum Server:
1)From command prompt, go to C:\win32app\Spectrum\mysql\bin
2)From C:\...\bin> mysql   uroot  -proot
3)At mysql> drop database netqos_integ;
4)Then, restart tomcat.
5)Then try to add the data source to the new CAPC system.

On Linux Spectrum Server:
1)From the /usr/Spectrum/mysql/bin directory, type the following:   
./mysql--defaults-file=../my-spectrum.cnf -uroot -proot
2)At mysql> drop database netqos_integ;
3)Then, restart tomcat.
4)Then try to add the data source to the new CAPC system.