HP StorageWorks P9000 Performance Advisor Software v5.2 Command-line User Interface Reference Guide (T1789-96316, May 2011)

Example 6. Exportdb 4
Exportdb -st 06.01.2007 18:00:00 -et 06.02.2007 10:00:00 -dkc 10055 -file
C:\export_db_dev14\test_jnl.xls -hr -dver 020000 -jnl
This command retrieves the data collected between 6 PM, 1st June 2007 and 10 AM, 2nd June 2007,
and places the data in a single text file named test_jnl.xls. The data collected is about the LDEVs
that belong to all the journals in the selected array.
Importing 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 Example 3). 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.
Retain the default values for the other fields, and click Next.
6. In Step 3 of 3 of the Text Import Wizard, note the highlighted column in the Data preview panel.
To highlight all the columns in the spreadsheet, 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 performance 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.
TOP20UTIL
Syntax
top20util [–dkc <serial #>] [mp <mp id>] [-L] [-hr] [-ms <URL>] [-auth
<user:passwd>] [-pf <password file>] [-d<delim>] [-st <mm.dd.yyyy
hh:mm:ss>] [-et <mm.dd.yyyy hh:mm:ss>]
Supported disk array types
P9000 disk arrays
Description
Enables you to get a list of the top 20 resource utilization data within a given time period. It displays
a list of the top 20 resources that use a particular MP blade, the associated processing type, and the
corresponding MP busy time.
The MP busy time indicates the time taken by an MP blade to process the request it receives from the
associated processing type.
CLUI commands56