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

Article Id: 3948
Status: Published
Updated On: 27-11-2019 15:37
Products:
CA Spectrum - OneClick , CA Spectrum - Reporting , CA Spectrum - Integrations , CA Spectrum - Alarms & Event Management
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.