I am archiving Spectrum Report Manager data but the reporting directory is not reducing in size.

Products

• CA Spectrum

Issue/Introduction

Using Archive or Purge options for SRM retention policy does not appear to be reclaiming disk space. How do I get that disk space back? 

Cause

This is because of how MySQL handles disk space and how it allocates it. The issue is that once MySQL has allocated disk space it will remain that size until the table is optimized.

Environment

Release: SDBSFO99000-10.2-Spectrum-Device Based Suite-Server FOC
Component:

Resolution

To optimized the tables and gain the disk space

1. on the OneClick server where SRM is installed, navigate to the $SPECROOT/mysql/bin directory
   
   In Windows, type the following: ./mysqlcheck -uroot -proot -o reporting
   In Linux, type the following: ./mysqlcheck --defaults-file=../my-spectrum.cnf -uroot -proot -o reporting
   
   
2. Let this run to completion. Note that if the Reporting database is large (over 100GB) then this process can take some time. Best to run the optimization on downtime, such as overnight or over a weekend. 

 

If you see any errors like this:"The storage engine for the table doesn't support optimize", it can be safely ignored. When complete, verify disk space has been regained.