Pre-requisites
The following are the pre-requisites to enable data aggregation in IT Analytics:
To enable the data aggregation, follow the steps as below:
Navigate to Administration >> System Configuration. System Configuration dialog box is displayed.
Click Database Administration tab.
Select the Enable data aggregation check box option.
The database tables must be partitioned in order to aggregate millions of records (composite partitioning Interval-List). The existing data in the specified non-partitioned tables will be transferred to the partitioned schema.
In order for Data Aggregation to know which columns require what types of aggregation and levels of aggregation, a one-time script execution is required to load the meta data for these chosen tables.
Data aggregation will begin with the nightly purge cycle after all of the above pre-requisite steps have been fulfilled. If the table is selected for aggregation by partitioning and metadata entry, the data for that table will first be aggregated before being purged, based on level-wise retention parameters.
Note:
Cohesity advise performing an environment assessment before enabling data aggregation. After the assessments, Cohesity includes separate scripts to divide any current tables that will benefit from data aggregation. Contact Veritas Support.