question

Mick H. avatar image
Mick H. asked ·

Purge some early implementation months from CAS & ADS Database

We would like to purge the first few months of data from the CAS and ADS as there were the initial months of our implementation and the data isn't valid and skews our results.

nam serverads
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Adam P. avatar image
Adam P. answered ·

Mick,

If you go to http://CAS/DiagConsole#/sp and decrease AMD_* parameters CAS will cut the tail of data during the night.

Just first make sure how much raw/daily/monthly data you have in DMI by plying with 1period/1day/1month resolutions.

Afterwards you may of course want to restore current setting to have CAS keep i.e. 2 years of daily aggregates in the future ...

4 comments Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

We are currently 8 months into our first year implementation.

If I understand you correctly, if I change the current 12 months value to 6, it would effectively remove the first 2 months overnight. It that correct?

0 Likes 0 · ·

No, changing AMD_MONTHLY_TRENDS_LEN property value from 12 to 6, will remove the oldest 6 months of monthly aggregates.

If you want to remove 2 oldest months you must change it from 12 to 10 it will.

0 Likes 0 · ·

So I made the change yesterday and did a test this morning by running a report on the "Last 12 months" in CAS for a Software Service. However, I still see the months of Feb and March which are the 2 oldest months that we wanted to remove. Did I need to restart the CAS?

0 Likes 0 · ·

Ups, maybe you need to wait for the end of the month, when the new montly aggregate is computed and old one(s) are removed ...

I will make sure and let you know.

0 Likes 0 · ·
Jean-Louis L. avatar image
Jean-Louis L. answered ·

No, it's not possible to purge a part of the historic.

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

David A. avatar image
David A. answered ·

The purge will definitively purge all the historic, the only way I see is going on the databaase side....And it is not easy, because in this historic if my memmory doesn't fails me, you have relationships at server/Sofware service level, that can be impacted.

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.