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.
Solved! See The Solution
4 REPLIES 4
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:
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.
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?