topic Re: acsview db compress in Network Access Control

acsview db compress

larsen_2011 — Mon, 11 Mar 2019 02:55:48 GMT

Hello all,

I performed the acsview db compress command on an ACS 5.3. The compression was done in about 20 minutes.. I wonder about the figures however.. when I check the sizes before and aftter, I dont really see the benefit. The size seems even larger after the compress.

Before the compress:

acsadmin(config-acs)# acsview show-dbsize

Actual DB Size (bytes) : 3146063872

Actual DB Size (GBs) :2.93

Physical DB Size (bytes):3176448000

Physical DB Size (GBs) :2.96

Physical ACSviewlog file Size (GBs) :1.38

After compressing DB:

Actual DB Size (bytes) : 3162824704

Actual DB Size (GBs) :2.95

Physical DB Size (bytes):3196493824

Physical DB Size (GBs) :2.98

Physical ACSviewlog file Size (GBs)

can anybody explain the numbers above ?

Thankx

Re: acsview db compress

Tarik Admani — Mon, 31 Dec 2012 23:32:14 GMT

Hi,

Is this acs also the log collector. From my experience the db compress are for the monitoring database.

thanks,

Sent from Cisco Technical Support iPad App

Re: acsview db compress

larsen_2011 — Tue, 01 Jan 2013 15:41:21 GMT

Hi Tarik,

The compression was done on the primary acs , which is also the log collector. i have a deployment of two Acs,primary and secondary. I am not quite sure what you mean by monitor?

regards,

Sent from Cisco Technical Support iPad App

acsview db compress

Satish Gaikwad — Thu, 03 Jan 2013 07:57:56 GMT

Hi Larsen,

I am having ACS 5.3.0.40 suprisingly there is no option for "acsview show-dbsize" command.

acsadmin(config-acs)# acsview show-dbbsize

% Invalid input detected at '^' marker.

Could you please confirm ACS version..

acsadmin(config-acs)# ?

access-setting Set administration access IP filtering

acsview-db-compress Start ACS View Database compress operation. (ACS will be shutdown for few moments)

ad-agent-clear-cache Set automatic clear cache for AD agent

ad-agent-configuration modify AD agent configuration

ad-agent-reset-configuration Reset AD agent configuration

database-compress Start ACS Database compress operation.(ACS will be shutdown for few moments)

debug-adclient Active directory client debug

debug-log Set debug log level per component

ethernet-interface change ethernet-interface configuration

exit Exit from the appliance interface.

export-data Export Utility

import-data Import Utility

import-export-abort abort import export processes

import-export-status status of import export processes

no Negate any command

replication Replication control command

replication_status Replication status command

reset-management-interface-certificate Sets the management Interface certificate to a default self signed certificate

show Show system settings

Thanks .

acsview db compress

jrabinow — Thu, 03 Jan 2013 08:04:48 GMT

This is available after installing patch 5.3.0.40.6 or a later patch