OneClick-Drive and memory Full

Products

• CA Spectrum

Issue/Introduction

Oneclick drive is getting filled with data.  What files can be cleaned to make space.

When we install Oneclick server with Report Manager then reporting database will keep occupying the space.

So we need to delete the unwanted data.

Environment

Spectrum 10.x
 

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
Stop Spectrum Tomcat Service
Move contents of archive folder
From %SPECROOT%\mysql\data\archive
To a tape or any other server where this space can be accommodated.
Start Spectrum Tomcat Service

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.

 

Additional Information

Please refer below link for Reporting Database Management
https://docops.ca.com/ca-spectrum/10-2-3/en/installing-and-upgrading/install-report-manager/maintenance-and-troubleshooting/reporting-database-management