beautypg.com

Export db csv files – HP XP Performance Advisor Software User Manual

Page 150

background image

MP blade. You can export data from the .csv files to a data visualization program, such as
Microsoft Excel. For more information about the generated .csv files, see

“Export DB CSV files”

(page 150)

.

The .csv files are created when you export data for a specified duration or schedule it as a daily,
weekly, or monthly activity. The .csv files are stored in the following location on the management
station: \HPSS\pa\tomcat\webapps\pa\reports.

You can perform the following tasks under the Export DB tab that appears when you click PA and
DB Settings+Database Manager in the left pane.

Export performance and utilization data into .csv files under the Export DB/Schedule Export
DB tab. You can save and view the .csv files when required, or schedule the export activities
on a periodic basis.

View the .csv files by selecting the corresponding records in the Exported DB Files section,
under the View Exported/Scheduled Exported DB Files tab.

Delete the records for the .csv files or the schedules in the Scheduled Export DB tasks section,
under the View Exported/Scheduled Exported DB Files tab.

The Export Database report functionality provided through the HP XP7 Performance Advisor GUI
is same as that available from CLUI.

Related Topics

“Creating Export DB CSV files” (page 153)

“Viewing Export DB CSV files” (page 158)

Export DB CSV files

This section describes the following .csv files you can view when you save or schedule an Export
DB report:

ldev_exportDB-array_serial_number_.csv

This file includes the following details:

The

XP/XP7 disk array serial number for which the report is generated.

The LDEVs present during the specified duration.

The RAID groups to which the LDEVs belong.

The performance data collection interval time stamps.

The data for the following metrics:

RIO Read Cache Hits, RIO Reads, RIO Write Cache Hits, and RIO Writes.

SIO Read Cache Hits, SIO Reads, SIO Write Cache Hits, and SIO Writes.

Total IO, Inhibit Mode IO Count, and Bypass Mode IO Count.

Backend Transfer Sequential Reads, Backend Transfer Non-Sequential Reads, and Backend
Transfer Writes.

Random MB Reads and Random MB Writes.

Sequential MB Reads and Sequential MB Writes.

Average Read Response Time (msec) data for every 200 msec and Maximum Read
Response Time (msec) data for the last 30 seconds.

Average Write Response Time (msec) data for every 200 msec and Maximum Write
Response Time (msec) data for the last 30 seconds.

150

Managing the HP XP7 Performance Advisor database