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.