Data Retention Periods for Historical and Performance Data Version 10.2.01P10

Purging Database Tables and Modifying Retention > Data Retention Periods for Historical and Performance Data

Version 10.2.01P10

Data Retention Periods for Historical and Performance Data

The data retention period for various database tables often can be modified to maintain reasonable table sizes. Data retention periods can be modified for the following types of data:

• Historical Data - A variety of log tables are updated during data collection.

• Performance Data - Performance data is collected for a variety of data object properties.

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), NetApp Cluster-Mode and Pure Storage.

For collected array LUN performance raw data, the default retention period (504 hours or 21 days) controls the retention of the data. When the daily performance data ages out, it gets deleted.

These sections include 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. Because of the large volume of historical and performance data that could be collected, data retention periods are set to defaults, but they can be modified to accommodate the needs of an enterprise. Follow the examples to modify the default values. See also, Configure Data Retention Periods and Customize Data Purging Retention Periods for SDK User-Defined Database Objects.

Reference the following sections for details.

• Capacity: Default Retention for Basic Database Tables

• Capacity: Default Retention for EMC Isilon Performance Tables

• Capacity: Default Retention for EMC Symmetrix Enhanced Performance

• Capacity: Default Retention for EMC VNX (Celerra) Array Tables

• Capacity: Default Retention for EMC VPLEX Array Tables

• Capacity: Default Retention for EMC XtremeIO Tables

• Capacity: Default Retention for Dell EMC Elastic Cloud Storage (ECS) Tables

• Capacity: Default Retention for Hitachi Array Database Tables

• Capacity: Default Retention for IBM Array Database Tables

• Capacity: Default Retention for IBM SVC Database Tables

• Capacity: Default Retention for NetApp Cluster-Mode Tables

• Capacity: Default Retention for NetApp Cluster-Mode Performance Data

• Capacity: Default Retention for Pure Storage FlashArray Tables

• Capacity: Default Retention for Host Resources Database Tables

• Cloud: Default Retention for Amazon Web Services (AWS) Tables

• Cloud: Default Retention for OpenStack Ceilometer Tables

• Virtualization: Default Retention for Database Tables

• SAN Fabric: Default Retention for Database Tables

• 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 Spectrum Protect (TSM) Database Tables

• System: Default Retention for Database Tables

• System: Data Collector Status Retention for Database Tables

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 See also, Activate/Deactivate LUN Performance Database Persistence.
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 Retention Period:

update ptl_system_parameter set param_value = '6'
where param_name = 'KEEP_SRM_CHARGEBACK_LOG_MONTHS';

Activate/Deactivate LUN Performance Database Persistence

In some environments, frequent database saves of LUN performance statistics can degrade Portal performance.

Use the system parameter: SAVE_LUN_PERF_HOURLY_DAILY_IS_ENABLED to activate/deactivate the process that saves LUN performance data to the database. APTARE IT Analytics is shipped with a value of 1, which indicates that the process is turned on. You can turn it off by changing the value to 0.

Use the following procedure to modify the IP match setting.

1. Log in to the Portal Server as user aptare.

2. Type the following command:

sqlplus portal/<portal_password>

3. Locate the default value:

SELECT param_value

FROM ptl_system_parameter

WHERE param_name='SAVE_LUN_PERF_HOURLY_DAILY_IS_ENABLED';

4. Update the parameter SAVE_LUN_PERF_HOURLY_DAILY_IS_ENABLED by changing the param_value. The default is 1, which indicates that the process is turned on. You can turn it off by changing the value to 0.

update ptl_system_parameter set param_value=0 WHERE

param_name='SAVE_LUN_PERF_HOURLY_DAILY_IS_ENABLED';

commit;

Capacity: Default Retention for EMC Isilon Performance Tables

For the retention periods for EMC Isilon array performance data, see Configure Data Retention Periods.

Table Description	Table Name	Default Retention	Notes
Protocol Performance	aps_isi_protocol_perform_hours	72 hours	KEEP_ISI_PROTOCOL_PERFORM_HOURS
	aps_isi_protocol_perform_log	6 months	KEEP_ISI_PROTOCOL_DAILY_PERFORM_MONTHS
	aps_isi_protocol_perform_log	21 days	KEEP_ISI_PROTOCOL_HOURLY_PERFORM_DAYS

Example of Customizing the EMC Isilon Performance Data Retention Period:

When you modify the KEEP_ISI_PROTOCOL_PERFORM_HOURS parameter, you are changing the purge interval for the Isilon performance table.

update ptl_system_parameter set param_value = '48'
where param_name = 'KEEP_ISI_PROTOCOL_PERFORM_HOURS';

Capacity: Default Retention for EMC Symmetrix Enhanced Performance

For the retention periods for EMC Symmetrix performance data, see Customize Data Purging Retention Periods for SDK User-Defined Database Objects.

Table Description	Table Name	Default Retention	Notes
Array Performance	SDK_esym_ARRAY_PERF	21 days	To modify the retention period, see Customize Data Purging Retention Periods for SDK User-Defined Database Objects.
Back-end Director Performance	SDK_esym_be_director_PERF	21 days
Database Performance	SDK_esym_database_PERF	21 days
Device Group Performance	SDK_esym_device_group_PERF	21 days
Disk Group Performance	SDK_esym_disk_group_PERF	21 days
Disk Performance	SDK_esym_disk_PERF	21 days
Disk Tech Pool Performance	SDK_esym_disk_tchpool_PERF	21 days
Front-end Director Performance	SDK_esym_fe_director_PERF	21 days
Front-end Port Performance	SDK_esym_fe_port_PERF	21 days
Storage Group Performance	SDK_esym_storage_grp_PERF	21 days
Storage Tier Performance	SDK_esym_storage_tier_PERF	21 days
Thin Pool Performance	SDK_esym_thin_pool_PERF	21 days
Thin Tier Performance	SDK_esym_thin_tier_PERF	21 days
Array's Cache Usage Performance	sdk_esym_array_cache_usage	21 days

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 EMC XtremeIO Tables

Table Description	Table Name	Default Retention	Notes
XtremIO Data Reduction Rate	sdk_exio_datareductionrate	15	To modify the retention period, see Customize Data Purging Retention Periods for SDK User-Defined Database Objects

Capacity: Default Retention for Dell EMC Elastic Cloud Storage (ECS) Tables

Table Description	Table Name	Default Retention	Notes
ECS Storage Array Performance	sdk_decs_ecsstg_ary_stats	21	To modify the retention period, see Customize Data Purging Retention Periods for SDK User-Defined Database Objects
ECS Replication Group Performance	sdk_decs_ecsrep_grp_stats	21	To modify the retention period, see Customize Data Purging Retention Periods for SDK User-Defined Database Objects
ECS Node Performance	sdk_decs_ecsnode_stats	21	To modify the retention period, see Customize Data Purging Retention Periods for SDK User-Defined Database Objects
ECS Node's Disk Performance	sdk_decs_ecsnodedisk_stats	21	To modify the retention period, see Customize Data Purging Retention Periods for SDK User-Defined Database Objects
ECS Storage Pools Performance	sdk_decs_ecsstg_pls_stats	21	To modify the retention period, see Customize Data Purging Retention Periods for SDK User-Defined Database Objects

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 IBM SVC Database Tables

The following table lists the retention period for the historical data that may need to be periodically purged.

Table Name	Default Retention	Parameter
aps_svc_storage_volume_log	24 months	KEEP_SVC_STRG_VOL_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

The following table lists the retention periods for the historical data that may need to be periodically purged. For the retention periods for NetApp Cluster-Mode performance data, see Capacity: Default Retention for NetApp Cluster-Mode Performance Data.

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 NetApp Cluster-Mode Performance Data

The following table lists the retention periods for the historical data that may need to be periodically purged. For the retention periods for NetApp Cluster-Mode historical data, see Capacity: Default Retention for NetApp Cluster-Mode Tables.

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

Capacity: Default Retention for Pure Storage FlashArray Tables

For the retention periods for Pure FlashArray performance data, see Customize Data Purging Retention Periods for SDK User-Defined Database Objects.

Table Description	Table Name	Default Retention	Notes
Array Performance	SDK_PURE_STORAGEARRAY_PERF	21 days	The Pure Storage Data Collector was deployed via the SDK. To modify the retention period, see Customize Data Purging Retention Periods for SDK User-Defined Database Objects.

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

Cloud: Default Retention for Amazon Web Services (AWS) Tables

For the retention periods for Amazon Web Services (AWS) data, see Customize Data Purging Retention Periods for SDK User-Defined Database Objects.

Table Description	Table Name	Default Retention	Notes
Billing Record Tag	SDK_aws_billing_rec_tag	366 days	The AWS Data Collector was deployed via the SDK. To modify the retention period, see Customize Data Purging Retention Periods for SDK User-Defined Database Objects.
Billing Record	sdk_aws_billing_record	367 days	The AWS Data Collector was deployed via the SDK. To modify the retention period, see Customize Data Purging Retention Periods for SDK User-Defined Database Objects. Note: The retention period for the billing record data must be one day more than the billing record tag data to ensure that the dependent tag data is removed before purging the billing record.

Cloud: Default Retention for OpenStack Ceilometer Tables

Table Description	Table Name	Default Retention	Notes
Instance Metrics	sdk_oscm_instance_metrics	15	To modify the retention period, see Customize Data Purging Retention Periods for SDK User-Defined Database Objects.
Network Metrics	sdk_oscm_network_metrics	15	To modify the retention period, see Customize Data Purging Retention Periods for SDK User-Defined Database Objects.
Disk Metrics	sdk_oscm_disk_metrics	15	To modify the retention period, see Customize Data Purging Retention Periods for SDK User-Defined Database Objects.

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 Virtualization Data Retention Period:

update ptl_system_parameter set param_value = '14'
where param_name ='KEEP_VMW_LOG_PERFORM_DATA_DAYS';

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 SAN Fabric 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 or 21 days	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 EMC Avamar 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
MTREE Compression log	apt_ddm_mtree_comp_log	2 months	KEEP_DDM_MTREE_LOG_MONTHS
Folder level compression log	aps_ddm_fldr_level_comp_log	2 months	KEEP_DDM_FOLDERLVL_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 Data Retention Period:

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 NetBackup Data Retention Period:

update ptl_system_parameter set param_value = '90'
where param_name =' KEEP_POLICY_AUDIT_DAYS';

Backup: Default Retention for IBM Spectrum Protect (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 Retention Period:

update ptl_system_parameter set param_value = '14'
where param_name = 'KEEP_POLL_DATE_LOG_DAYS';

System: Data Collector Status Retention for Database Tables

The following parameters can be modified to control how much historical Data Collector status data is retained. Historical data is retained for both scheduled collection and test runs of collection. The following logic applies:

• Data for inactive collections is retained for the default 90 days or for whatever is configured for KEEP_COLL_PROBE_STATE_MAX_DAYS.

• Data for active (both scheduled and test) collections is retained for the default 7 days or for whatever is configured for KEEP_COLL_PROBE_STATE_ACTIVE_DAYS.

• Each data collector probe’s last run data is always retained until the policy or collector is deleted.

• If a Data Collector is removed, a single record is retained and all other related history is purged.

Table Description	Table Name	Default Retention	Notes
Data collector probe status	apt_coll_probe_state	90 days	KEEP_COLL_PROBE_STATE_MAX_DAYS
Data collector probe status	apt_coll_probe_state	7 days	KEEP_COLL_PROBE_STATE_ACTIVE_DAYS

Examples of Customizing the Data Collector Status Data Retention Period:

UPDATE ptl_system_parameter SET param_value = 60 WHERE param_name='KEEP_COLL_PROBE_STATE_MAX_DAYS';

COMMIT;

UPDATE ptl_system_parameter SET param_value = 10 WHERE param_name='KEEP_COLL_PROBE_STATE_ACTIVE_DAYS';

COMMIT;