how to purge ocum databse?

[elic_co]

Hello,

Is there a way to run a manual purging of the mysql db in ocum to reduce the number of objects? (for example old resolved and obsolete events)

I mainly want to clear all the events that were ever saved and shrink the table.

Old and resolved events should be deleted and unresolved events just should be re-discovered in the next 15 minutes after an ocum monitoring round.

Achieving this from the mysql command line is also an options.

Thanks

[marz]

There is no supported method to purge Events manually.

However, Unified Manager (rebranded as Active IQ Unified Manager from OnCommand Unified Manager with the 9.6 release) has inroduced a feature to allow you to set Event Retention and Performance Data Retention in the UM 9.6 release.  You may view the Help for this feature here:  https://library.netapp.com/ecmdocs/ECMLP2853092/html/frameset.html. 

Screenshot for the feature view with defaults:

Screenshot for the feature view with warning when Performance Data Retention interval is less than Event Retention interval:

[elic_co]

Thank you very much for the help.

Is there an unsupported way to perform that? I realize that it's a risk that I take on myself and I'll be sure to take a full backup of the ocum server before that.

[marz · Accepted solution]

There was no method developed for manual purging of only Event data as the in-product feature was on the roadmap (and released already).

[elic_co]

ok thanks.

sorry for insisting but is there an unsupported way to purge all data manually? let's say I want to keep data for less than 1 month that the builtin data retention offers, I want to keep them for 2 weeks only. how do I do that?

thanks again,