Resolving High Disk Space Size in Report Manager

Article Id: 40122

Status: Published

Updated On: 14-02-2018 07:36

Legacy Id: TEC1921496

Products:

CA Spectrum - OneClick , CA Spectrum - Reporting , CA Spectrum - Integrations , CA Spectrum - Alarms & Event Management

Issue/Introduction:

Question:

How to resolve High disk Space Size in Report manager?

Answer:

First we will truncate the event table and then we need to reinitialize the report manager .

Below are the steps to truncate the event table .

From the OneClick Server / reportmanagerserver :

cd $SPECROOT/mysql/bin
./mysql --defaults-file=../my-spectrum.cnf -uroot -proot reporting truncate table event;

NOTE :Truncating the event table will completely wipe out the SRM database event data.

Now we need to reinitialize the Report Manager :

Below are the steps :

· stop the spectrum tomcat service on the oneclick/srm server .

· cd $SPECROOT/bin

· RpmgrInitializeLandscape.sh root root -initHist 45 -all

once that command completes

· you can restart the spectrum tomcat service

Additional Information:

Reinitialize the SRM db which will wipe out all data in all theSRM tables and then pull over the last 45 days worth of data from the archive managers/SpectroServers that SRM is monitoring.

Environment:

Release:
Component: SPCRPT