Since the Migration to ACS 5.5.0.46 we keep seeing the following message in the alarm inbox
Cisco Secure ACS Alarm (CRITICAL): Physical size of ACS db is more than 50% of its Actual Size.
Cisco Secure ACS - Alarm Notification
Severity: Critical
Alarm Name
System Alarm [Database Purging]
Cause/Trigger
Physical size of ACS db is more than 50% of its Actual Size.
Alarm Details
Physical size of ACS db is more than 50% of its Actual Size.The size will be reduced after purge ACS transaction log and compress ACS db.
Generated On
Mon Mar 17 05:00:06 CET 2014
ACS View Database Compression and Backup is configured and runs without error:
The Backup Job stores a maximum of 4 Months to a FTP Server.
Fullbackup: Monthly
Incremental: Weekly
DB: Compression activated
Purge and Incremental Backup History
Name
Start Time
End Time
Status
DatabasePurge-Job
Mon Mar 17 04:00:00 CET 2014
Mon Mar 17 04:00:00 CET 2014
as far as I can see from the CLI there should be an oversized DB:
ACS21/acsadmin(config-acs)# acsview show-dbsize Actual DB Size (bytes) : 1585192960 Actual DB Size (GBs) :1.48 Physical DB Size (bytes):1605386240 Physical DB Size (GBs) :1.5 Physical ACSviewlog file Size (GBs) :0 ACS21/acsadmin(config-acs)# exit
ACS21/admin# show application status acs
ACS role: PRIMARY
Process 'database' running Process 'management' running Process 'runtime' running Process 'adclient' running Process 'ntpd' running Process 'view-database' running Process 'view-jobmanager' running Process 'view-alertmanager' running Process 'view-collector' running Process 'view-logprocessor' running
"The ACS Database needs to be compressed as a part of maintenance operation. You can run the acsview-db-compress command from acs-config mode to reduce the physical size of the view database when there is a difference between the physical size and actual size of the view database. ACS 5.5 stops only the log collector services during compress operation and will be up and running after the compress operation is completed. You need to enable the log recovery feature to recover the log messages that are received during the database compress operation.
In ACS 5.5, database compress operation is automated. You can check the Enable ACS View Database Compress check box to compress the ACS View database automatically every day at 5 A.M. The database compress operation is run everyday automatically at 5 A.M whenever there is a need."
I already tried to manually compress the DB via "acsview-db-compress" without any effect.
Go here: http://supportforums.cisco.com/discussion/12143331/physical-size-acs-db-more-50-its-actual-size-acs-version-55046
Getting Started
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:
