Spectrum Report Manager uses too much disk space, how can we limit the size of this database?

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

Spectrum Report Manager uses too much disk space, how can we limit the size of this database?

The $SPECROOT/mysql/data/reporting directory is very large and taking up a major part of the disk space. The solution explains what to do to reduce the disk space used.

Environment

Release: Any

Resolution

To limit the size of the Spectrum Report Manager database:

CA suggests having a large enough hard space drive dedicated to Report Manager to store all the data required for your business needs.

Spectrum Report Manager also has an archiving utility. This utility is located under the Admin Tools tab of the Report Manager UI. This utility has three features: Purge, Archive, and All data.

          Purge: Remove all data based on retention period days chosen
          Archive: Archive the data into the archive database based on the retention period days chosen
          All data: Keep all data in the reporting database and do not remove anything. All data basically means the archiver will not run each night.

Purge is the recommended setting for users with disk space problems. This will remove all the data after the retention period chosen. For example, if you set the retention days to 90, then anything older than 90 days is removed on a nightly basis.

Archive can be used but this does not save space. Archive simply moves the data from one database to another. However, the archive database can be dropped. This action would make that amount of space available and upon restarting spectrum tomcat, the database will be rebuilt with 0 data.

To drop the archive database:

1. Navigate to the $SPECROOT/mysql/bin directory.
2. Type: ./mysql --defaults-file=my-spectrum.cnf -uroot -p<passwd>
3. At the Mysql> prompt type: drop database archive;
4. Restart Spectrum Tomcat service.