Effective December 3, NetApp adopts Microsoft’s Business-to-Customer (B2C) identity management to simplify and provide secure access to NetApp resources.
For accounts that did not pre-register (prior to Dec 3), access to your NetApp data may take up to 1 hour as your legacy NSS ID is synchronized to the new B2C identity.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

Accessing the Sybase DB for perf data

ASELVANAYAGAM

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

1 ACCEPTED SOLUTION

adaikkap

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

View solution in original post

10 REPLIES 10

adaikkap

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

View solution in original post

ASELVANAYAGAM

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

ASELVANAYAGAM

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

adaikkap

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

ASELVANAYAGAM

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.

adaikkap

Hi Arun,

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

Regards

adai

ASELVANAYAGAM

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

Thanks,

Arun

adaikkap

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

ASELVANAYAGAM

Thank you so much!

ASELVANAYAGAM

Thanks Adai.

Arun

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public