Data Infrastructure Management Software Discussions

how to purge ocum databse?

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

 

4 REPLIES 4

Re: how to purge ocum databse?

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:

DataRetention-Warning.jpg

 

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

DataRetention-Defaults.jpg

Re: how to purge ocum databse?

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.

Re: how to purge ocum databse?

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

Re: how to purge ocum databse?

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,

Forums