Report Manager data disk space near capacity

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

MySQL reporting folder is occupying disk space near capacity.  What files should be removed to free up disk space?

Environment

All supported DX NetOps Spectrum releases with SRM CABI Integration configured

Resolution

Login to oneclick server

Check the size of %SPECROOT%\mysql\data\archive and reporting folders

If Archive folder is consuming the space then it is safe to move the data to another server / tape

Below are the steps
1. Stop Spectrum Tomcat Service
2. Copy contents of archive folder
From %SPECROOT%\mysql\data\archive
(To a tape or any other server where this space can be accommodated)

3. Login to mysql and drop the archive database:

Windows

mysql -uroot -p<passwd>

RHEL

./mysql --defaults-file=../my-spectrum.cnf -uroot -p<passwd>

4. DROP DATABASE archive; 

5.  Start Spectrum Tomcat Service (empty Archive database will be created)

NOTE:
Always ensure that the drive has a minimum 3 times of disk space free of reporting folder (%SPECROOT%\mysql\data)

Example:
If Report Manager folder is of 10 GB then 30GB of free space should be available in that drive.