ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Capacity Database - data retention rollup issue
Article ID: 199654
Updated On:
Products
CA Capacity Manager
MICS Resource Management
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
Feedback
Yes
No
Powered by
