topic Re: how to purge ocum databse? in Active IQ Unified Manager Discussions

how to purge ocum databse?

elic_co — Sun, 25 Aug 2019 15:12:34 GMT

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

Re: how to purge ocum databse?

marz — Mon, 26 Aug 2019 15:19:23 GMT

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:

Re: how to purge ocum databse?

elic_co — Tue, 27 Aug 2019 16:26:08 GMT

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?

marz — Tue, 27 Aug 2019 17:57:08 GMT

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?

elic_co — Tue, 27 Aug 2019 19:44:52 GMT

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,

Re: how to purge ocum databse?

BobG — Thu, 11 May 2023 23:27:14 GMT

There is a way to effect manual purging of events. This depends on the OCUM/ActiveIQ API, which was actually quite rich in functionality. I don't know if it has extended to more recent versions, last time I used it was against the first AIQUM 9.x release.

First, get yourself the NetApp Management SDK from the Support site. The NMSDK documents all the old ZAPI calls as well as the effective equivalent of the ZAPI calls to OCUM/AIQUM. Use the "perl bindings" section as it provides the most complete list of APIs and parameters. Whoever did the Perl stuff for the SDK - whether you use perl or not - did us all a huge favor. The normal way to make a ZAPI call was to manually build the XML to submit to the Controllers/OCUM. The perl bindings made each API into a function call that would automatically build the XML from the parameters provided and similarly automatically unwind the response XML data on return. Even if you don't use perl - the documentation here is the most complete.

In any case - the process was to first iterate all the events, say more recent than a particular date but only up to a certain date. Then, be sure the event is marked "resolved" - another API call. Then when all events are iterated and resolved, there is a "purge" call that will purge all resolved events.

The API to OCUM/AIQUM was never well publicized. These similar calls did not make the REST transition to my knowledge. But with a little digging, you can find all kinds of capabilities in these tools.

Bob