Exporting data
The Export Data option exports the Performance Monitoring (PCM) data metrics that are collected for the specified time. You can export the Performance Monitoring data metrics that is displayed in the dashboard into a folder on your local system.
About this task
You can export data metrics by accessing the HMC.
To export data metrics for one or more servers, complete the following steps:
Procedure
-
In the navigation pane, click Resources.
- Click All Systems. The All Systems page is displayed.
- Select the server for which you want to view the performance data.
- Click Actions > Performance Data Collection > Export Data.
The Export PCM Data page is displayed with the information for that system. - In the upper-right corner of the Performance Monitoring section, click the Data Collection menu.
-
Click Export Data.
The Export Data page is displayed.
- The data collection can be turned on or turned off using the toggle switch in the Data Collection menu.
-
Select the feed by which you want to export the performance metrics.
PCM metrics have the following rollup or aggregation frequency and retention period:
- Tier 0 level - The aggregation frequency is 30 seconds and the retention period is 2 hours.
- Tier 1 level - The aggregation frequency is 5 minutes and the retention period is 24 hours.
- Tier 2 level - The aggregation frequency is 2 hours and the retention period is 7 days.
- Tier 3 level - The aggregation frequency is 24 hours and the retention period is 180 days.
When you select the feed as By Source, multiple data files that contain overall resource level data are exported for each managed system, logical partition, and Virtual I/O Server (VIOS). When you select the feed type as By Tier, the maximum tier level is calculated based on the time duration that is specified in start time stamp and end time stamp, and the data for corresponding level is exported.Note:If you select the feed type as By Tier and the export format is CSV, two files are created, one for the managed system and one for the logical partition, as compared to a single file in the JavaScript Object Notation (JSON) format.
-
Select the export format as either JavaScript Object Notation (JSON) or
comma-separated values (CSV).
The CSV file represents data of JSON file content in the CSV format.
-
Click the calendar icon to choose the Start Date and End
Date.
By default, the time stamp in the Start Date is set to 4 hours before the current time, and the current time is set as the time stamp in the End Date. You can choose to export data for this duration. Otherwise, to specify specific time interval, you must enter the time within the Performance Monitoring data retention period, which is 180 days by default. The time stamp of the last data export is displayed in gray.
- Click OK. The Confirm Download dialog box is displayed with the name of the file that contains the exported data.
- Click OK to download the exported data in a compressed format.
- Depending on your browser setting, you can choose the destination folder in which the exported data must be saved.