You can reset the default data retention limits for call detail records, interval data, daily data, monthly data, and login or logout data.
Procedure
Log in to the Cluster Control Manager (CCM) console as the customer user.
Switch to being the root user by entering the command su.
To run the Analytics Administration script, use the following command:
ccm release orca analytics
Select Database by pressing the corresponding number.
To select the Data retention limits option, enter the corresponding number.
To select the Set Data Retention limits option, enter the corresponding number.
In the Proceed to setting data retention limits option, type y.
Entering n cancels the operation.
The CCM console displays the list of the items for which you want to set the data retention limits. The options are:
Call Detail Records
Interval Data
Daily Data
Monthly Data
Login/Logout Data
Agent Trace Data
List all
In the Select from the above which data retention limit you would like to set field, enter the corresponding number of the item from the list you want to set.
For Call Detail Records
In the Enter the new limit value field, enter the value in days before which you want the system to remove the CDR data.
The maximum value is 365 days.
Return to the previous page by entering b.
Quit the current page by entering q.
Return to the main menu by entering m.
For Interval Data
In the Enter the new limit value field, enter the value in months before which you want the system to drop the partitions for the interval tables.
The maximum value is 12 months.
Return to the previous page by entering b.
Quit the current page by entering q.
Return to the main menu by entering m.
For Daily Data
In the Enter the new limit value field, enter the value in months before which you want the system to drop the partitions for the interval tables.
The maximum value is 60 months.
Return to the previous page by entering b.
Quit the current page by entering q.
Return to the main menu by entering m.
For Monthly Data
In the Enter the new limit value field, enter the value in months before which you want the system to drop the partitions for the interval tables.
The maximum value is 9999 months.
Return to the previous page by entering b.
Quit the current page by entering q.
Return to the main menu by entering m.
For Agent Trace Data
In the Enter the new limit value field, enter the value in days before which you want the system to remove the Trace date.
The maximum value is 365 days.
Return to the previous page by entering b.
Quit the current page by entering q.
Return to the main menu by entering m.
For Login/Logout Data
In the Enter the new limit value field, enter the value in months before which you want the system to drop the partitions for the interval tables.
