Purging Database Tables and Modifying Retention > Configure Data Retention Periods
  
Version 10.2.01P10
Configure Data Retention Periods
Note: This section covers the procedure for modifying data retention periods for systems that are collected by traditional Data Collectors. For systems collected by Data Collectors deployed via the SDK, use the procedure described in: Customize Data Purging Retention Periods for SDK User-Defined Database Objects.
Use the following procedure to modify the retention period for array performance by updating database system parameters.
1. Log in to the Portal Server as user aptare.
2. Type the following command:
sqlplus portal/<portal_password>
3. To find the current value of the parameter in the System Parameters, use this command, substituting the <parameter_name> using the list in Data Retention Periods for Historical and Performance Data.
 
SELECT param_value
FROM ptl_system_parameter
WHERE param_name='<parameter_name>';
 
4. Update the system parameter by substituting the new interval for <new_value>.
 
UPDATE ptl_system_parameter set param_value=<new_value> WHERE param_name='<parameter_name>';
commit;
 
See Data Retention Periods for Historical and Performance Data for the names to substitute for <parameter_name>.