Example 3. E xportdb 1
Exportdb st 07.06.2001 11:00:00 et 07.06.2001 12:00:00 file 0706export.txt
-dkc 31045
This comma nd retrieves the data collected between 11am and noon, and places the d ata 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
showninthenextexample.
Example 4. Expor td b 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. Expo rtdb 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,andclpr_filename.
If you specify the –dver 010600, the output is generated in three separate text files:
(dkc_filename) — DKC-specific per formance data
(ldev_filename) — LD EV-specific performance data
(por t_filename) — port-specificperformancedata
Thedataisexportedinacomma-delimitedfile. The first line contains the column headers for the data
that follows. All other lines contain performance da ta.
Importing t he data to MS Excel
To impor t the d ata into Excel, complete the following steps:
1. Open the exportdb file using MS Excel (0706export.txt as referred to in Example 3). This
launchestheTextImportWizard.
2. In Step 1 of 3 oftheTextImportWizard,selectDelimited(default).
3. Enter 1 in the Startimportatrowfield, 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 d elimiters if checked.
Leave all other fields as the defaults, and click Next.
6. In Ste p 3 of 3 of the Text Impor t Wizard, note the highlighted column in the Data preview panel. You
must highlight all the colu m ns in the spreadsheet. To do so, press Shi f t 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 co rner cell between cells A and 1. This highlights the entire spreadsheet. G o to Format on
the menu bar, select Column, and then select AutoFit Sele ction. This sizes all the columns to fitthetext.
The MS Excel performance data sheet is now comp lete.
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
Komentarze do niniejszej Instrukcji