Purging Database Tables and Modifying Retention Periods > Capacity: Default Retention for Host Resources Database Tables
  
Version 10.0.01
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