Resolving High Disk Space Size in Report Manager

Products

• CA Spectrum

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