
4 Datab ase Adminis tration
C ommands
The PA XP CLUI supports the following commands for database administration:
ExportDB Comm
and
You can use the
ExportDB command to export data, for charting or graphing, and including the Ext-Lun
information
to a data visualization program, such as Microsoft Excel. The output of the ExportDB
command for t
he dkc per formance d ata contains the m aximum configuration of an XP12000 array, even
though the X
P10000 array has a maximum of 4 C HIPs and 2 ACPs. This is because there are 16
CHIPs and 8 A
CPs columns. However, if the column is not applicable for XP10000, it displays the text
"Invalid" as a column heading. For mix PCBs, the column displays the label "Invalid Mp" as a column
heading for MPs 4 to 7.
NOTE:
PA XP supports multiple data collection. To ensur e that the exportdb command is successful, create one
schedule w
ith all components selected and set the same frequency of collection.
Example 1. Schedule 1
Components selected:
Raid group
:1-2
Frequency
of collection: 1 min
Example2. Schedule2
Components selected:
DKC
Raid group: Leftover raid groups by the first schedule.
Port: All the available ports.
Frequency
of collection: 30 mins (for all the above components)
ExportDB usage
Following are the required parameters for the exportDB command:
–st <time string>
–et <time string>
–dkc <serial #>
Optionally, you can specify a managem ent station by using –ms <URL>, and specify a username and
password pair by using –auth <user:passwd>.Youcanuse–pf <password file> in place of
auth. The –dver <XXXXXX> command displays the E xt-Lun information.
Following is the general format of the comma nd to invoke the script:
exportdb [-d<delim>] [-L] [-hr] [-ms <URL>] [-auth <user:passwd>] [-st
<mm.dd.yyyy hh:mm:ss>] [-et <mm.dd.yyyy hh:mm:ss>] [-file <filename>] -dkc
<serial #> -dver <XXXXXX> [-?]
where:
HP StorageWorks Performance Advisor XP Software command-line user interface user guide
79
Comentarios a estos manuales