Purging Database Tables and Modifying Retention Periods
  
Version 10.0.01
Purging Database Tables and Modifying Retention Periods
This section includes lists of the length of time that data is retained before being purged from the database. For example, if the retention is set to 180 days, the last 180 days of data will be available for reports. Follow the examples to modify the default values. See also, Configure Array Performance Data Retention Periods.
Capacity: Default Retention for Basic Database Tables
Capacity: Default Retention for EMC Isilon Performance Tables
Capacity: Default Retention for EMC VNX (Celerra) Array Tables
Capacity: Default Retention for EMC VPLEX Array Tables
Capacity: Default Retention for Hitachi Array Database Tables
Capacity: Default Retention for IBM Array Database Tables
Capacity: Default Retention for NetApp Cluster-Mode Tables
Capacity: Default Retention for Host Resources Database Tables
Virtualization: Default Retention for Database Tables
SAN Fabric: Default Retention for Database Tables
Example of Customizing the Data Retention Period:
Backup: Default Retention for General Backup Database Tables
Backup: Default Retention for EMC Avamar Database Tables
Backup: Default Retention for Data Domain Database Tables
Backup: Default Retention for HP Data Protector Database Tables
Backup: Default Retention for EMC NetWorker Database Tables
Backup: Default Retention for Veritas NetBackup Tables
Backup: Default Retention for IBM TSM Database Tables
System: Default Retention for Database Tables
 
See also, Configure Array Performance Data Retention Periods.
Capacity: Default Retention for Basic Database Tables
Table Description
Table Name
Default Retention
Notes
File system log
aps_file_system_log
6 months
KEEP_FILE_SYSTEM_LOG_MONTHS
LUN performance log
apt_lun_perform_log
504 hours
KEEP_LUN_RAW_PERFORM_HOURS
Array group log
aps_array_group_log
12 months
KEEP_ARRAY_GROUP_LOG_MONTHS
Array port statistics log
aps_array_port_stats_log
1 day
KEEP_ARRAY_PORT_STAT_LOG_DAYS
Array port statistics daily log
aps_array_port_stats_daily_log
2 months
KEEP_ARRAY_PORT_STAT_DAILY_LOG_MONTHS
Capacity chargeback log
aps_chargeback_log
24 months
KEEP_SRM_CHARGEBACK_LOG_MONTHS
Host processing log
apt_host_process_log
15
KEEP_HOST_PROCESS_LOG_DAYS
Example of Customizing the Chargeback Monthly Log Data:
update ptl_system_parameter set param_value = '6'
where param_name = 'KEEP_SRM_CHARGEBACK_LOG_MONTHS';
Capacity: Default Retention for EMC Isilon Performance Tables
For the retention periods for EMC Isilon raw, hourly, and daily array performance data, see Configure Array Performance Data Retention Periods
Table Description
Table Name
Default Retention
Notes
Disk Performance
aps_isi_disk_perform_hr
6 months
KEEP_ISI_LOG_MONTHS
Array Performance
aps_isi_array_perform_hr
6 months
KEEP_ISI_LOG_MONTHS
Node Performance
aps_isi_node_perform_hr
6 months
KEEP_ISI_LOG_MONTHS
Protocol Performance
aps_isi_protocol_perform_hr
6 months
KEEP_ISI_LOG_MONTHS
OneFS Performance
aps_isi_onefs_perform_hr
6 months
KEEP_ISI_LOG_MONTHS
Daily data that is older than the last 6 months (defined in the system parameter KEEP_ISI_LOG_MONTHS) is purged as a normal process. This process is scheduled for the Monday after the 15th of every month at 7:00 a.m.
Example of Customizing the EMC Isilon Performance Data:
When you modify the KEEP_ISI_LOG_MONTHS parameter, you are changing the purge interval for all Isilon performance tables.
update ptl_system_parameter set param_value = '4'
where param_name = 'KEEP_ISI_LOG_MONTHS';
Capacity: Default Retention for EMC VNX (Celerra) Array Tables
Table Description
Table Name
Default Retention
Notes
Volume Log
aps_vnx_volume_log
90 days
KEEP_VNX_LOG_MONTHS
Storage Pool Log
aps_vnx_storage_pool_log
90 days
KEEP_VNX_LOG_MONTHS
Filesystem Log
aps_vnx_file_system_log
90 days
KEEP_VNX_LOG_MONTHS
Capacity: Default Retention for EMC VPLEX Array Tables
Table Description
Table Name
Default Retention
Notes
Storage Volume Log
aps_vpl_storage_volume_log
12 months
KEEP_VPL_STORAGE_VOLUME_LOG_MONTHS
Virtual Volume Log
aps_vpl_virtual_volume_log
12 months
KEEP_VPL_VIRTUAL_VOLUME_LOG_MONTHS
Capacity: Default Retention for Hitachi Array Database Tables
Table Description
Table Name
Default Retention
Notes
Hitachi journal pool log
aps_hds_journal_pool_log
3 months
KEEP_HDS_LOG_MONTHS
Hitachi ldev log
aps_hds_ldev_log
3 months
KEEP_HDS_LOG_MONTHS
Capacity: Default Retention for IBM Array Database Tables
Table Description
Table Name
Default Retention
Notes
IBM array log
aps_ibm_array_log
12 months
KEEP_IBM_LOG_MONTHS
IBM array site log
aps_ibm_array_site_log
12 months
KEEP_IBM_LOG_MONTHS
Capacity: Default Retention for NetApp Database Tables
Table Description
Table Name
Default Retention
Notes
Historic aggregate
aps_nap_aggregate_log
12 Months
KEEP_NAP_AGGREGATE_LOG_MONTHS
Historic volume
aps_nap_volume_log
12 Months
KEEP_NAP_VOLUME_LOG_MONTHS
Historic QTree
aps_nap_qtree_log
12 Months
KEEP_NAP_QTREE_LOG_MONTHS
Historic quota
aps_nap_quota_log
12 Months
KEEP_NAP_QUOTA_LOG_MONTHS
Historic snapshot
aps_nap_snapshot_log
6 Months
KEEP_NAP_SNAPSHOT_LOG_MONTHS
Historic CIFS share
aps_napn_cifs_share_log
12 Months
KEEP_NAPN_CIFS_SHARE_LOG_MONTHS
Historic LUN
aps_naps_lun_log
12 Months
KEEP_NAPS_LUN_LOG_MONTHS
Historic array
aps_storage_array_log
12 Months
KEEP_SRM_LOG_MONTHS
Capacity: Default Retention for NetApp Cluster-Mode Tables
For the retention periods for NetApp Cluster-Mode performance data, see Configure Array Performance Data Retention Periods.
Table Description
Table Name
Default Retention
Notes
Aggregate log
aps_ntc_aggregate_log
12 months
KEEP_NTC_AGGREGATE_LOG_MONTHS
Snapshot log
aps_ntc_snapshot_log
6 months
KEEP_NTC_SNAPSHOT_LOG_MONTHS
Volume log
aps_ntc_volume_log
12 months
KEEP_NTC_VOLUME_LOG_MONTHS
LUN log
aps_ntc_lun_log
12 months
KEEP_NTC_LUN_LOG_MONTH
Node log
aps_ntc_node_log
12 months
KEEP_NTC_NODE_LOG_MONTHS
Quota log
aps_ntc_quota_log
12 months
KEEP_NTC_QUTOA_LOG_MONTHS
Capacity: Default Retention for Host Resources Database Tables
These Host Resources tables are for logs that may need to be periodically purged.
Table Description
Table Name
Default Retention
Notes
Host Data Collection Logs
Host collector log details
apt_host_collector_log_detail
10 days
KEEP_COLLECTOR_LOG_DAYS
Host collector log
apt_host_collector_log
10 days
KEEP_COLLECTOR_LOG_DAYS
Host collector log details
apt_host_collector_log_detail
1 hour
KEEP_PAYLOAD_LOG_HOURS
Host collector log
apt_host_collector_log
1 hour
KEEP_PAYLOAD_LOG_HOURS
Host allocated but unused log
aps_host_alloc_unused_log
24 months
KEEP_HOST_ALLOC_LOG_MONTHS
Host CPU log
apt_host_cpu_log
90 days
KEEP_HOST_CPU_LOG_DAYS
Host device performance log
apt_host_device_perf_log
90 days
KEEP_HOST_DEVICE_PERF_LOG_DAYS
IBM ASM Database Tables
Client disk I/O log
aps_asm_dbclient_diskio_log
2 months
KEEP_ASM_LOG_MONTHS
Disk I/O log
aps_asm_diskio_log
2 months
KEEP_ASM_LOG_MONTHS
Disk log
aps_asm_disk_log
2 months
KEEP_ASM_LOG_MONTHS
Host Resource Database Application
Database application data files log
aps_database_datafiles_log
12 months
KEEP_APP_LOG_MONTHS
Database application instance log
aps_database_instance_log
12 months
KEEP_APP_LOG_MONTHS
Virtualization: Default Retention for Database Tables
These Virtualization Manager tables are for logs that may need to be periodically purged.
Table Description
Table Name
Default Retention
Notes
Datastore log
apt_vmw_datastore_log
3 Months
KEEP_VMW_LOG_MONTHS
Performance CPU
apt_vmw_perform_cpu_hr
3 Months
KEEP_VMW_LOG_MONTHS
Performance Disk
apt_vmw_perform_disk_hr
3 Months
KEEP_VMW_LOG_MONTHS
VM Guest Disk
apt_vmw_vmguest_disk_log
3 Months
KEEP_VMW_LOG_MONTHS
Virtual Machine
APT_VMW_VIRTUAL_MACHINE_LOG
3 Months
KEEP_VMW_LOG_MONTHS
Partition Status
APT_VMW_PARTITION_STATS_LOG
3 Months
KEEP_VMW_LOG_MONTHS
Performance Memory
APT_VMW_PERFORM_MEMORY_HR
30 Days
KEEP_VMW_LOG_PERFORM_DATA_DAYS
Example of Customizing the Data Retention Period:
update ptl_system_parameter set param_value = '6'
where param_name =' KEEP_AFA_OWNER_LOG_MONTHS';
SAN Fabric: Default Retention for Database Tables
These Fabric Manager tables are for logs that may need to be periodically purged.
Table Description
Table Name
Default Retention
Notes
Fibre channel port log
aps_swi_switch_fc_port_log
6 months
KEEP_SWI_FC_PORT_LOG_MONTHS
Performance volume log
aps_swi_perform_vol_log
14 days
KEEP_SWI_PERFORM_VOL_LOG_DAYS
Performance error log
aps_swi_perform_err_log
28 days
KEEP_SWI_PERFORM_ERR_LOG_DAYS
Performance daily log
aps_swi_perform_daily_log
365 days
KEEP_SWI_PERFORM_DAILY_LOG_DAYS
Example of Customizing the Data Retention Period:
update ptl_system_parameter set param_value = '21'
where param_name =' KEEP_SWI_PERFORM_VOL_LOG_DAYS';
File Analytics: Default Retention for Database Tables
These File Analytics tables are for logs that may need to be periodically purged.
Table Description
Table Name
Default Retention
Notes
Data growth log
apt_afa_data_growth_log
6 Months
KEEP_AFA_DATA_GROWTH_LOG_MONTHS
File size log
apt_afa_file_size_log
6 Months
KEEP_AFA_FILE_SIZE_LOG_MONTHS
Largest file log
apt_afa_largest_files_log
6 Months
KEEP_AFA_LARGEST_FILE_LOG_MONTHS
File type log
apt_afa_file_types
6 Months
KEEP_AFA_FILE_TYPE_LOG_MONTHS
File category log
apt_afa_file_category
6 Months
KEEP_AFA_FILE_CATEGORY_LOG_MONTHS
File lifetime log
apt_afa_file_lifetime_log
6 Months
KEEP_AFA_FILE_LIFETIME_LOG_MONTHS
File summary log
apt_afa_file_summary_log
4 Months
KEEP_AFA_FILE_SUMMARY_LOG_MONTHS
File duplication log
apt_afa_file_duplication_log
6 Months
KEEP_AFA_FILE_DUPLICATION_LOG_MONTHS
File capacity log
apt_afa_file_capacity_log
6 Months
KEEP_AFA_CAPACITY_LOG_MONTHS
Owner category log
apt_afa_owner_category_log
2 Months
KEEP_AFA_OWNER_LOG_MONTHS
Backup: Default Retention for General Backup Database Tables
Table Description
Table Name
Default Retention
Notes
Backup job messages log
apt_job_message_log
120 days
Cannot be modified *
Skipped backup files
apt_skipped_backup_file
180 days
Cannot be modified *
Tape drive log
apt_tape_drive_log
180 days
Cannot be modified *
Backup job file (file details)
apt_job_file
30 days
Cannot be modified *
Top backup jobs file (file details)
apt_top_job_file
30 days
Cannot be modified *
Backup client file (file details)
apt_client_file
30 days
Cannot be modified *
Report execution tracking
apt_execution_tracking
90 days
Cannot be modified *
Host process log
apt_host_process_log
60 days
Cannot be modified *
Host CPU log
apt_host_cpu_log
60 days
Cannot be modified *
Host network log
apt_host_network_log
60 days
Cannot be modified *
Host memory log
apt_host_memory_log
60 days
Cannot be modified *
Database error log
apt_scon_error
10K rows
Cannot be modified *
* Future software versions may enable modifications.
 
Backup: Default Retention for EMC Avamar Database Tables
Table Description
Table Name
Default Retention
Notes
Node utility log
apt_avm_node_util_log
6 months
Can be modified using parameter:
KEEP_AVM_LOG_MONTHS
See example below.
Node space log
apt_avm_node_space_log
6 months
Can be modified using parameter:
KEEP_AVM_LOG_MONTHS
See example below.
Example of Customizing the Data Retention Period:
update ptl_system_parameter set param_value = '3'
where param_name ='KEEP_AVM_LOG_MONTHS';
Backup: Default Retention for Data Domain Database Tables
Table Description
Table Name
Default Retention
Notes
Filesystem log
apt_ddm_file_system_log
12 months
KEEP_DDM_FILE_SYS_LOG_MONTHS
Compression log
apt_ddm_compression_log
12 months
KEEP_DDM_COMPRESSION_LOG_MONTHS
Logical storage unit log
apt_ddm_lgcl_strg_unit_log
12 months
KEEP_DDM_LSU_LOG_MONTHS
Virtual tape library log
apt_ddm_virtl_tape_lib_log
2 months
KEEP_DDM_VTL_LOG_MONTHS
Disk performance log
apt_ddm_disk_perf_log
2 months
KEEP_DDM_DISK_LOG_MONTHS
System log
apt_ddm_system_log
2 months
KEEP_DDM_SYSTEM_LOG_MONTHS
Backup: Default Retention for HP Data Protector Database Tables
Table Description
Table Name
Default Retention
Notes
Skipped backup files
apt_hpd_skipped_backup_file
180
Cannot be modified *
Session messages
apt_hpd_session_message
See notes.
Retention between:
(sysdate-180) and (sysdate-120)
Message Log
apt_hpd_session_message_log
90 days
KEEP_HPD_SESSION_MSG_LOG_DAYS
* Future software versions may enable modifications.
Example of Customizing the Message Log retention:
update ptl_system_parameter set param_value = '30' where param_name ='KEEP_HPD_SESSION_MSG_LOG_DAYS';
 
Backup: Default Retention for EMC NetWorker Database Tables
Table Description
Table Name
Default Retention
Notes
Job messages
apt_leg_job_message
See notes.
Retention between:
(sysdate-180) and (sysdate-120)
Backup: Default Retention for Veritas NetBackup Tables
Table Description
Table Name
Default Retention
Notes
Job state
apt_nbu_job_state
60 days
Cannot be modified *
Image log
apt_nbu_image_log
180 days
Cannot be modified *
Schedule log
apt_nbu_schedule_log
180 days
Can be modified using parameter:
KEEP_POLICY_AUDIT_DAYS
See example below.
Backup job tape media
apt_nbu_job_tape_media
180 days
Can be modified using parameter:
KEEP_NBU_JOB_TAPE_DAYS
See example below.
Backup job file
apt_nbu_job_file
180 days
Can be modified using parameter:
KEEP_NBU_JOB_HISTORY_DAYS
See example below.
Backup job try
apt_nbu_job_try
180 days
Cannot be modified *
Backup related job
apt_nbu_related_job
180 days
Cannot be modified *
NetBackup Policy Auditing:
Backup policy client audit
apt_nbu_policy_client_aud
180 days
Can be modified using parameter:
KEEP_POLICY_AUDIT_DAYS
Maximum value is limited to 180 days.
See example below.
Backup policy log
apt_nbu_policy_log
180 days
Can be modified using parameter:
KEEP_POLICY_AUDIT_DAYS
See example below.
* Future software versions may enable modifications.
Example of Customizing the Data Retention Period:
update ptl_system_parameter set param_value = '90'
where param_name =' KEEP_POLICY_AUDIT_DAYS';
Backup: Default Retention for IBM TSM Database Tables
Table Description
Table Name
Default Retention
Notes
TSM occupancy log
apt_tsm_occupancy_log
120 days
Can be modified using parameter:
KEEP_OCCUPANCY_LOG_DAYS
See example below.
TSM storage pool log
apt_tsm_storage_pool_log
120 days
Cannot be modified *
TSM database log
apt_tsm_database_log
120 days
Cannot be modified *
TSM job messages
apt_tsm_job_message
120-180 days
Cannot be modified *
TSM sessions
apt_tsm_session
120-180 days
Cannot be modified *
TSM drive media log
apt_tsm_drive_media_log
120-180 days
Cannot be modified *
TSM job media loaded
apt_tsm_job_media_loaded
120-180 days
Cannot be modified *
* Future software versions may enable modifications.
System: Default Retention for Database Tables
Table Description
Table Name
Default Retention
Notes
Poll date log
apt_poll_date_log
10 days
KEEP_POLL_DATE_LOG_DAYS
Poll date audit
apt_poll_date_audit
10 days
KEEP_POLL_DATE_AUDIT_DAYS
Report execution tracking
apt_execution_tracking
90 days
KEEP_EXECUTION_TRACKING_DAYS
Example of Customizing the Poll Date Log Data:
update ptl_system_parameter set param_value = '14'
where param_name = 'KEEP_POLL_DATE_LOG_DAYS';