Remove entries from Analytics DB

[Maria Joseph Vimalan]

Dear Experts, 

We are running Automic version 21.0 SP5 HF2. We have multiple production clients and there is an special client which executes lot of transactions per day.
We have analytics to keep a track of success percentage and other information for the management .  With 180 days of retention period, the size of the Analytics DB  is around 250GB.  We have now another requirement to increase the retention period to 540 days. 

We have couple of clients where we dont need to store the information in the Analytics DB. So is there any possibility of removing entries from Analytics DB only for certain clients ? 

Your input is highly welcomed. Thank you

Regards
Vimalan

[Krum Ganev]

Hello Maria,

It is generally possible but not with the ActionPack from Broadcom.
You will need to write your own sql query for that. (example : delete from ah_cleaned where ah_client = <your client> and ah_timestamp4 < NOW() - INTERVAL '90 days' )

In general the tables in Analytics are similar to the AE ones.
There was one good article from Philipp Elmer back in the days - LINK

The concept of Analytics Datastore : (*Note : could be slightly outdated)

And columns : 

In one of our systems we do not care about the LASLM (SLO Objects), hence on some regular intervals i am truncating LASLM and LASLM_CLEANED.
On few occasions we had issue with the table size and allocated storage (vaccum was failing as there was not enough space left) and to resolved that i also truncated AH and AH_ENRICHER.
All of  the analytics widgets are using the AH_CLEANED table and generally you only need that one to make reports even without the widgets.

I assume Broadcom had some sort of plan what to do with AH and AH_ENRICHER after staging them, but nothing was implemented and they are left there as big chunks of data. (or maybe my understanding is wrong?)

------------------------------
------------------------------
Automic SME @ DXC.Technology
------------------------------
------------------------------