Configure System Parameters > Configure Array Performance Data Retention Periods
  
Version 10.0.01
Configure Array Performance Data Retention Periods
Array performance data is collected from certain storage arrays:
• NetApp ONTAP Cluster-Mode arrays
• Isilon arrays
• Array LUN performance statistics are collected for Dell Compellent, EMC VNX (CLARiiON), EMC Symmetrix, HDS Tuning Manager, HP 3PAR, IBM SVC, IBM XIV, NetApp ONTAP (Block only), and NetApp Cluster-Mode.
 
For collected array LUN performance data, default retention periods (raw, hourly, and daily) control the retention of the data, as shown in the following list. At each data collection cycle, APTARE StorageConsole determines which data needs to be aggregated and moved to the next period. When the daily performance data ages out, it gets deleted. These defaults represent contiguous interval periods.
• Raw - Kept for 72 hours (3 days)
• Hourly - From the 4th day for an interval of 21 days
• Daily - From the 24th day for an interval of 180 days (6 months)
 
 
See also, Purging Database Tables and Modifying Retention Periods.
Use the following procedure to modify the retention period for array performance data in the 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 Default Retention Periods for Array 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 Default Retention Periods for Array Performance Data for the names to substitute for <parameter_name>.
Default Retention Periods for Array Performance Data
 
Database Table
Default Value
Parameter Name
NetApp Cluster
12 months
KEEP_NTC_NODE_LOG_MONTHS
NetApp Cluster
12 months
KEEP_NTC_QUOTA_LOG_MONTHS
NetApp Cluster
6 months
KEEP_NTC_SNAPSHOT_LOG_MONTHS
NetApp Cluster
72 hours
KEEP_NTC_AGGREGATE_RAW_PERFORM_HOURS
NetApp Cluster
6 months
KEEP_NTC_AGGREGATE_DAILY_PERFORM_MONTHS
NetApp Cluster
12 months
KEEP_NTC_AGGREGATE_LOG_MONTHS
NetApp Cluster
21 days
KEEP_NTC_AGGREGATE_HOURLY_PERFORM_DAYS
NetApp Cluster
72 hours
KEEP_NTC_PROCESSOR_RAW_PERFORM_HOURS
NetApp Cluster
6 months
KEEP_NTC_PROCESSOR_DAILY_PERFORM_MONTHS
NetApp Cluster
21 days
KEEP_NTC_PROCESSOR_HOURLY_PERFORM_DAYS
NetApp Cluster
72 hours
KEEP_NTC_TARGET_PORT_RAW_PERFORM_HOURS
NetApp Cluster
6 months
KEEP_NTC_TARGET_PORT_DAILY_PERFORM_MONTHS
NetApp Cluster
21 days
KEEP_NTC_TARGET_PORT_HOURLY_PERFORM_DAYS
NetApp Cluster
72 hours
KEEP_NTC_CIFS_RAW_PERFORM_HOURS
NetApp Cluster
6 months
KEEP_NTC_CIFS_DAILY_PERFORM_MONTHS
NetApp Cluster
21 days
KEEP_NTC_CIFS_HOURLY_PERFORM_DAYS
NetApp Cluster
12 months
KEEP_NTC_VOLUME_LOG_MONTHS
NetApp Cluster
72 hours
KEEP_NTC_VOLUME_RAW_PERFORM_HOURS
NetApp Cluster
6 months
KEEP_NTC_VOLUME_DAILY_PERFORM_MONTHS
NetApp Cluster
21 days
KEEP_NTC_VOLUME_HOURLY_PERFORM_DAYS
NetApp Cluster
72 hours
KEEP_NTC_PROCESSOR_NODE_RAW_PERFORM_HOURS
NetApp Cluster
6 months
KEEP_NTC_PROCESSOR_NODE_DAILY_PERFORM_MONTHS
NetApp Cluster
21 days
KEEP_NTC_PROCESSOR_NODE_HOURLY_PERFORM_DAYS
NetApp Cluster
72 hours
KEEP_NTC_FCP_LIF_RAW_PERFORM_HOURS
NetApp Cluster
6 months
KEEP_NTC_FCP_LIF_DAILY_PERFORM_MONTHS
NetApp Cluster
21 days
KEEP_NTC_FCP_LIF_HOURLY_PERFORM_DAYS
NetApp Cluster
72 hours
KEEP_NTC_SMB_RAW_PERFORM_HOURS
NetApp Cluster
6 months
KEEP_NTC_SMB_DAILY_PERFORM_MONTHS
NetApp Cluster
21 days
KEEP_NTC_SMB_HOURLY_PERFORM_DAYS
NetApp Cluster
72 hours
KEEP_NTC_RAID_RAW_PERFORM_HOURS
NetApp Cluster
6 months
KEEP_NTC_RAID_DAILY_PERFORM_MONTHS
NetApp Cluster
21 days
KEEP_NTC_RAID_HOURLY_PERFORM_DAYS
NetApp Cluster
12 months
KEEP_NTC_LUN_LOG_MONTHS
NetApp Cluster
72 hours
KEEP_NTC_LUN_RAW_PERFORM_HOURS
NetApp Cluster
6 months
KEEP_NTC_LUN_DAILY_PERFORM_MONTHS
NetApp Cluster
21 days
KEEP_NTC_LUN_HOURLY_PERFORM_DAYS
NetApp Cluster
72 hours
KEEP_NTC_SYSTEM_RAW_PERFORM_HOURS
NetApp Cluster
6 months
KEEP_NTC_SYSTEM_DAILY_PERFORM_MONTHS
NetApp Cluster
21 days
KEEP_NTC_SYSTEM_HOURLY_PERFORM_DAYS
NetApp Cluster
72 hours
KEEP_NTC_DISK_RAW_PERFORM_HOURS
NetApp Cluster
6 months
KEEP_NTC_DISK_DAILY_PERFORM_MONTHS
NetApp Cluster
21 days
KEEP_NTC_DISK_HOURLY_PERFORM_DAYS
NetApp Cluster
72 hours
KEEP_NTC_NFS_RAW_PERFORM_HOURS
NetApp Cluster
6 months
KEEP_NTC_NFS_DAILY_PERFORM_MONTHS
NetApp Cluster
21 days
KEEP_NTC_NFS_HOURLY_PERFORM_DAYS
Isilon
72 hours
KEEP_ISI_PROTOCOL_PERFORM_HOURS
Isilon
6 months
KEEP_ISI_PROTOCOL_DAILY_PERFORM_MONTHS
Isilon
21 days
KEEP_ISI_PROTOCOL_HOURLY_PERFORM_DAYS
LUN
21 days
KEEP_LUN_RAW_PERFORM_HOURS