Capacity Database - data retention rollup issue

book

Article ID: 199654

calendar_today

Updated On:

Products

CA Capacity Manager

Issue/Introduction

Data retention configured as 90 days for Hourly data and 365 Days for daily sample data.

We need to verify the data retention rollup running properly & old data does it deleting or not ?  Please help us on this.


Cause

The rollup data is stored in the CCC database, as follows:

  • Hourly data is stored in entity_hour_fact.
  • Daily data is stored in entity_day_fact.
  • Baseline data for CCC and VPM is stored in entity_baseline_fact.

The hourly and daily tables also contain group level metrics used by CCC

Environment

Release : 2.94

Component : CA CAPACITY MANAGER

Resolution

Run below select commands from CCC database

select min(insert_date) as first, max(insert_date) as Last from entity_hour_fact

select min(insert_date) as first, max(insert_date) as Last from entity_day_fact

select min(insert_date) as first, max(insert_date) as Last from entity_baseline_fact

Additional Information

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/capacity-management/2-9-4/administrating/capacity-command-center-administration/configure-the-precalculation-rollup-settings/understanding-precalculation-rollups/rollup-data-storage.html