topic Re: OCUM SQL Table descriptions in Active IQ Unified Manager Discussions

OCUM SQL Table descriptions

thywyn222 — Wed, 04 Jun 2025 14:29:50 GMT

Does anyone know of any documentation of the tables spaces for OCUM. I can't seems to find descriptions of the data and what it is supposed to be. Sure I can make assumptions but I'd rather have some documentation.

Re: OCUM SQL Table descriptions

Dhiman — Thu, 12 Oct 2017 05:36:47 GMT

Hi,

There is no seperate documentation for all the tables in the exposed schema(s). More so since, the DB schemas are very extensive and its very difficult to fit it into a documentaiton.

You can, however, connect the schema with any tool/IDE of your choice and look at each table descriptions. You can as well, run table description from your UM instance (if you deployed it on a RHEL/Windows).

Hope this helps!

Regards,

Dhiman

Re: OCUM SQL Table descriptions

skdineshkumar — Mon, 25 Nov 2019 15:58:26 GMT

Hi Dhiman,

I have gone through your article TR-4709. It was really helpful. Thanks for this!

I'm looking to query the performance data for volumes.

In page no. 10, I could see "The tables with the prefix sample_* are 5-minute samples that are stored in the Unified Manager database for 30 days."

But I cannot find any particular table in "netapp_performance" schema that is holding the 5-minutes sample of volume performane that consists of IOPs, Latency and Throughput.

Can help me specify which particular table is holding the above data?

thanks,

Dineshkumar