Modeloutage.ibd is too big

Document ID : KB000115868
Last Modified Date : 26/09/2018
Show Technical Document Details
Introduction:
In the <SPECROOT>/mysql/data/reporting directory, the modeloutage.ibd file is too large.  
Instructions:
If you need to reduce size you can do the following:

Open a command line 
Run bash -login 
Go to the msyql/bin directory 
run the command: 

./mysql -uroot -proot reporting 


<You should see a MYSQL prompt> 

once logged into mysql do the following: 

truncate table event; 

and 

truncate table modeloutage; 

then type 'exit' 

Then go to the $Specroot/bin directory and rerun the rpmgrinitializelandscape tool. You'll need to replace the <landscape> in the command: 

./RpmgrInitializeLandscape.sh root root -initHist 45 <landscape> 

Caution-https://communities.ca.com/thread/241700862