topic Re: Accessing the Sybase DB for perf data in Active IQ Unified Manager Discussions

Accessing the Sybase DB for perf data

ASELVANAYAGAM — Thu, 05 Jun 2025 06:02:27 GMT

I am trying to query some of the tables in the DFM schema in the Sybase database with a user that has GlobalRead. I am unable to do that. I am only able to query the views in the DFMGROUP schema and I am able to look at the data via views. However there are some data in the tables that are of interest to me. How should the user account be setup to be able to query the tables under the DFM schema? Are there any help info regarding that?

Thanks,

Arun

Re: Accessing the Sybase DB for perf data

adaikkap — Thu, 30 May 2013 15:32:59 GMT

Hi Arun,

Only those under DFM views which are DFMGroup can be queried. Those other than what is exposed in DFM views are not exposed.

Here is the link to the TR that clearly details how to access the DFM.

http://media.netapp.com/documents/tr-3690.pdf

Also can you pls move this post the following community ? OnCommand Unified Manager

https://communities.netapp.com/community/products_and_solutions/storage_management_software/oncommand-unified-manager

Regards

adai

Re: Accessing the Sybase DB for perf data

ASELVANAYAGAM — Fri, 31 May 2013 15:02:52 GMT

Hi Adai,

May be I am totally wrong here, because I am not very familiar with what products are packaged into the DATA ONTAP solution. Currently we have DATA ONTAP 7MODE and I was told that we will be moving cluster mode very soon. Will this provide access to the tables in the DFM schema, or it won't be available in Cluster mode either ?

Thanks,

Arun

Re: Accessing the Sybase DB for perf data

adaikkap — Mon, 24 Jun 2013 13:11:11 GMT

Hi Arun,

I am not clear on your question. The schema for DFM is same irrespective of 7Mode or clustermode. As a volume is a volume in both 7 and C mode. But there are new consturcts like vServer and lif etc which are not exposed via these view at least for CMode.

Regards

adai

Re: Accessing the Sybase DB for perf data

ASELVANAYAGAM — Tue, 25 Jun 2013 14:43:54 GMT

Hi Adai,

Thanks for the response. I meant to ask if it is possible to query the tables in the DFM database, because right now it looks like we can only access Views in the DFM Sybase database.

Re: Accessing the Sybase DB for perf data

adaikkap — Tue, 25 Jun 2013 14:50:33 GMT

Hi Arun,

Only views are supported and exposed and not the dfm tables or its schema.

Regards

adai

Re: Accessing the Sybase DB for perf data

ASELVANAYAGAM — Tue, 25 Jun 2013 15:37:19 GMT

Thanks Adai.

Arun

Re: Accessing the Sybase DB for perf data

ASELVANAYAGAM — Wed, 26 Jun 2013 16:58:53 GMT

Is there a help doc somewhere that explains what the different fields in the Views in the Sybase database represent?

Thanks,

Arun

Re: Accessing the Sybase DB for perf data

adaikkap — Wed, 26 Jun 2013 17:06:55 GMT

Hi Arun,

Only the view schema is documented, under the following 2 locations

Operations Manager Console> Control Center > Help >General Help > Database Schema.
OnCommand Console > Help >Contents > Reports >Database schema

Regards

adai

Re: Accessing the Sybase DB for perf data

ASELVANAYAGAM — Thu, 27 Jun 2013 14:13:27 GMT

Thank you so much!

Re: Accessing the Sybase DB for perf data

ASELVANAYAGAM — Tue, 23 Jul 2013 18:54:51 GMT

Hi Adai,

I wanted to revisit this conversation -- so is the document tr-3690.pdf (http://media.netapp.com/documents/tr-3690.pdf) applicable for both 7-Mode and Cluster Mode? Also, what is the NetApp recommended method to view performance data -- via database views or API ?

Thanks,

Arun