Database table ACM_ARC is big and contains million of rows

Products

• CA Configuration Automation

Issue/Introduction

Database ACM_ARC contains more than 1 million of rows and is very big. It takes a lot of disk space.
Why and how to decrease its size ?

Environment

Configuration Automation - All Versions

Cause

This table contains server snapshots and "Diff and Compliance result" containers.
By default snapshots are automatically deleted after 1 week but if the automatic deletion has been disabled for some management profiles in Snapshot Deletion Options, number of rows in table ACM_ACR could increase indefinitely

Resolution

Make sure that all Management Profiles have some Snapshot Deletion Options set :

1. Go in Management - Management Profiles :
   
   
   
   
2. Click on one Management Profile.
3. Click on Management Options tab and on Snapshots.
   Specify some settings for "Snapshot Deletion Options" :
   
   Select a Maximum Count and/or a Maximum Age.
   
   
4. Do the same for all Management Options

Additional Information

Once a snapshot is deleted, the orphan server instance record are automatically deleted by a cleanup task.
By default cleanup task is executed every 24 hours. But this is configurable with parameter cleanup.execution.interval :

This cleanup task will delete more rows in table ACM_ARC
And in the log we could see lines like this :

2025-02-20 12:36:36,069 INFO  [Grid Job <uuid>] com.ca.acm.server.discovery.common.DiscoveryUtils (DiscoveryUtils.java:1182) - Delete 1 orphan server instance records which are no longer used by diff/compliance result.