How to resolve High disk Space Size in Report manager?
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 :
./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
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.