Purging Database Tables > Capacity Manager: Host Resources Database Tables
   
Version 9.1
Capacity Manager: 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
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