HP StorageWorks XP Performance Advisor Software v4.6 User and Troubleshooting Guide (T1789-96094, June 2010)

Creating and viewing Export DB CSV files

XP Performance Advisor retrieves performance values related to DKC, LDEVs, ports, and CLPRs for

an XP array, and provides the data in separate .csv files that you can export to a data visualization

program such as Microsoft Excel. These .csv files are created when you choose to export the

performance values for a specified duration of your choice, or schedule this activity periodically, on

a daily, weekly, or monthly basis. If you choose to export the performance values on a need basis,

you can view the generated .csv files immediately or save them in XP Performance Advisor to view

them later. If you choose to schedule the export activity, the .csv files are created as per the schedule

and appropriate records are stored in XP Performance Advisor. You can view the reports when

required. In addition, you can also view performance values of LDEVs that belong to a Journal pool

and also utilization values for Ext-LUNs, and RAID groups. All 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 Database

Manager in the left pane.

• Export DKC, LDEVs, ports, CLPRs performance values into .csv files under the Export DB/Schedule

Export DB tab. You can generate or save 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 XP Performance Advisor GUI is same

as that available from the CLUI.