Importing the data to ms excel, Exportdb sample output – HP XP Performance Advisor Software User Manual
Page 81

Example 3. Exportdb 1
Exportdb st 07.06.2001 11:00:00 et 07.06.2001 12:00:00 file 0706export.txt
-dkc 31045
This command retrieves the data collected between 11am and noon, and places the data in a single
text file named 0706export.txt. Using this command, without the -dver switch, ensures that the output
produced is consistent with PA Version 1.05.00.
If you want the output to be consistent with the PA Version 1.06.00 formatting, use the –dver switch, as
shown in the next example.
Example 4. Exportdb 2
Exportdb st 07.06.2001 11:00:00 et 07.06.2001 12:00:00 file 0706export.txt
-dkc 31045 -dver 010600
Example 5. Exportdb 3
exportdb -st 02.23.2006 16:15:00 -et 02.23.2006 17:15:00 -file export.csv
-dkc 10851 -dver 020000 rgutil -hr
This command generates a new file containing the RAID GROUP–specific performance data,
rgutil_filename, along with the following files: dkc_filename, ldev_filename,
port_filename, and clpr_filename.
If you specify the –dver 010600, the output is generated in three separate text files:
(dkc_filename) — DKC-specific performance data
(ldev_filename) — LDEV-specific performance data
(port_filename) — port-specific performance data
The data is exported in a comma-delimited file. The first line contains the column headers for the data
that follows. All other lines contain performance data.
Importing the data to MS Excel
To import the data into Excel, complete the following steps:
1.
Open the exportdb file using MS Excel (0706export.txt as referred to in
). This
launches the Text Import Wizard.
2.
In Step 1 of 3 of the Text Import Wizard, select Delimited (default).
3.
Enter 1 in the Start import at row field, and select Windows (ANSI) in the File origin field.
4.
Click Next.
5.
In Step 2 of 3 of the Text Import Wizard, select Comma, and clear any other delimiters if checked.
Leave all other fields as the defaults, and click Next.
6.
In Step 3 of 3 of the Text Import Wizard, note the highlighted column in the Data preview panel. You
must highlight all the columns in the spreadsheet. To do so, press Shift while navigating to the last
column using the scroll bar, and then click the last column. All columns must be highlighted.
7.
Click Text in the Column data format panel, and click Finish. The spreadsheet is populated with
PA XP data.
8.
Select the corner cell between cells A and 1. This highlights the entire spreadsheet. Go to Format on
the menu bar, select Column, and then select AutoFit Selection. This sizes all the columns to fit the text.
The MS Excel performance data sheet is now complete.
ExportDB sample output
The following are output data samples for the CLUI shell script described in the previous section:
exportdb -st 09.16.2003 05:00:00 -et 09.16.2003 07:15:00 -file output.txt
-dkc 10033 -dver 020000 hr
The following is the portion of data in output file ldev_output.txt, which contains the Ext-Lun
configuration data and Cache Partitioning information. The information is appended to the end of each
HP StorageWorks Performance Advisor XP Software command-line user interface user guide
81