Purging Database Tables and Modifying Retention Periods Version 10.0.00

Purging Database Tables and Modifying Retention Periods

Version 10.0.00

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

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’;