Community

Subscribe
Highlighted
Accepted Solution

Accessing the Sybase DB for perf data

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

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

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

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

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

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

Thanks Adai.

Arun

Re: Accessing the Sybase DB for perf data

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

Hi Arun,

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

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

Regards

adai

Re: Accessing the Sybase DB for perf data

Thank you so much!