Active IQ Unified Manager Discussions

how to export performance data from OnCommand server?

BIGBUG_008
5,473 Views

My OnCommand server has a high disk usage, i check the performance data is large.

How can i export performance data and delete it from OnCommand server?

6 REPLIES 6

BIGBUG_008
5,473 Views

Nobody can take care of this question?

adaikkap
5,473 Views

Hi,

     What is the version of OCUM that you are running ?

If you are running a version prior to 5.0 you may be a victim of bug 439756

http://support.netapp.com/NOW/cgi-bin/bol?Type=Detail&Display=439756

Pls take a look at the below TR on how to control the data collection  and retention of perf data. Refer the section 14. Data Collection Page 69

http://www.netapp.com/us/system/pdf-reader.aspx?m=tr-4090.pdf&cc=us

Also OCUM allows you to export PA data and the same is describe in TR 3690

http://www.netapp.com/us/system/pdf-reader.aspx?m=tr-3690.pdf&cc=us

Alternate way is to use the dfm perf data retrieve cli to extract only the data that is required.

Hope this helps.

Regards

adai

BIGBUG_008
5,473 Views

Thank you for your update.

We are running 5.0.2 as it is a FIX version of bug 439756.

I checked tr-4090 and tr-3690 .but i do not known the following questions.

Can i export the PA historical data to CSV file manually?

Can i delete the PA historical data (form YYYYMMDD -- YYYYMMDD) manually?

adaikkap
5,473 Views

Hi,

Can i export the PA historical data to CSV file manually?

I am not sure if you got to see the section titled in TR-3690, Scenario 3: Exporting PA data to CSV or tab-separated text files.

Can i delete the PA historical data (form YYYYMMDD -- YYYYMMDD) manually?

You cant specify a time range, but as described in TR4090 Section 14. Data Collection, you can modify the retention. By default for most view data work 1year is kept unless you changed them.

So now if you change it to 6months then all data older than 6months from now are deleted from the PA flat files.

hope this helps.

Regards

adai

BIGBUG_008
5,473 Views

thank you for your reply.

i checked TR-3690, Scenario 3. and i known that solution to export PA data to CSV files.

but with that solution. i can not save date by the month.

I found dfm perf data export command can export PA date by the month to binary files in Counter Manager Archive (CMA) format.

how to open the CMA format binary files?

Are there any other solutions to export PA data by the month?

BIGBUG_008
5,473 Views

Hi,

I tried to export PA data manually using dfm data export run command.

The recent data can be exported but the the old data can not be exported.

Why?

C:\>dfm data export run -d comma -t 60 -f avg -h "1 days" MYHOST

Option dfmDataExportEnabled is not set. Set this option to enable export of DataFabric Manager server data.

Created data export directory "\\myserver\d$\temp\OnCommand\export_201310161405".

Started Performance Advisor data export.

Exported host information from which counter data is collected.

Exported Performance Advisor counter information.

Exported counter data for "system" object type on host "MYHOST".

Exported counter data for "disk" object type on host "MYHOST".

Exported counter data for "aggregate" object type on host "MYHOST".

Exported counter data for "ifnet" object type on host "MYHOST".

Exported counter data for "nfsv3" object type on host "MYHOST".

Exported counter data for "nfsv4" object type on host "MYHOST".

Exported counter data for "volume" object type on host "MYHOST".

Exported counter data for "cifs" object type on host "MYHOST".

Exported counter data for "vfiler" object type on host "MYHOST".

Exported counter data for "processor" object type on host "MYHOST".

Exported counter data for "qtree" object type on host "MYHOST".

Completed export of Performance Advisor data in 731 second(s).

Data Export completed successfully.

C:\Users\ZSYS093>dfm data export run -d comma -t 60 -f avg -h "204 days" MYHOST

Option dfmDataExportEnabled is not set. Set this option to enable export of DataFabric Manager server data.

Created data export directory "\\myserver\d$\temp\OnCommand\export_201310161632".

Started Performance Advisor data export.

Exported host information from which counter data is collected.

Exported Performance Advisor counter information.

Failed to fetch perf data for system counters on host MYHOST. Reason - HTTP POST - Timed out

Deleted the export directory.

Public