Creating export db csv files – HP XP P9000 Performance Advisor Software User Manual
Page 152
This file includes the following details:
•
The XP or the P9000 disk array serial number for which the report is generated.
•
The RAID group IDs on the XP or the P9000 disk array.
•
The performance data collection interval time stamps.
•
The frontend random read and write I/Os on all the LDEVs in a RAID group over the collection
interval.
•
The utilization of the RAID group over the collection interval for writing random and sequential
parity.
•
The frontend sequential read and write I/Os on all the LDEVs in a RAID group over the
collection interval.
•
The total utilization of a RAID group over a collection interval.
When a RAID group is associated with a ThP pool, this metric provides the extent of RAID
group utilization due to the I/Os occurring on a ThP pool.
jnl_exportDB-array_serial_number_
This file includes the following details:
•
The XP or the P9000 disk array serial number for which the report is generated.
•
The journal group IDs on the XP or the P9000 disk array.
•
The performance data collection interval time stamps.
•
The MU indicates the mirror unit number.
•
The CTG indicates the consistency group Id.
•
The JNLS indicates the journal pool status.
•
The AP indicates the number of active paths.
•
The U(%) indicates the usage rate (%) of the journal data.
•
The Q-Marker indicates the latest sequence # for writing to the PVOLs consistency group at
the PAIR state.
•
The Q-CNT shows the number of remaining Q-Markers within the journal data.
•
The Num indicates the total number of LDEVs configured as the journal volumes.
•
The LDEV # indicates the cu:ldev ID that is configured as the journal volume.
Creating Export DB CSV files
IMPORTANT:
•
If you have logged in with user privileges, you cannot schedule the export DB activity.
•
Only a single .csv file is created for the XP1024/128 Disk Arrays.
•
020000 is the supported version for the P9000 disk arrays, such as the P9500 and the
following XP disk arrays, XP24000, XP20000, XP12000, XP10000, and the SVN Disk Arrays.
•
020000 is also the supported version if you want to view the external LUN information.
•
010600, 016000, and 020000 are the supported versions for the XP1024/128 Disk Arrays.
•
016000 or 020000 are the supported versions to view the response time values in the .csv
files.
•
Unlike the database purge and archival procedures, the Export DB activity does not affect the
database size. It only exports data from the database into the .csv files.
To export data or schedule the export activity:
152
Managing the HP XP P9000 Performance Advisor database