HP Neoview Release 2.5 Software - Manual (Page 45)

Table 3-6 DISK_STATS_V1 Field Definitions (continued)
Description Data Type Field Name
Output kilobytes per second during
this interval for the primary disk DECIMAL(9,1) OUTPUT_KB_PER_SEC
Number of disk process read
operations per second for this interval,
for the mirror disk DECIMAL(9,1) READS_PER_SEC_MIR
Number of disk process write
operations per second for this interval,
for the mirror disk DECIMAL(9,1) WRITES_PER_SEC_MIR
Total number of disk process reads,
writes, and seeks per second for this
interval, for the mirror disk DECIMAL(9,1) OPS_PER_SEC_MIR
Percentage of time that the mirror disk
was busy reading, writing, and seeking
during this interval DECIMAL(6,1) BUSY_PCT_MIR
Percentage of time that the mirror disk
was busy writingduring this interval DECIMAL(6,1) BUSY_WRITES_PCT_MIR
Percentage of time that the mirror disk
was busy reading during this interval DECIMAL(6,1) BUSY_READS_PCT_MIR
Input kilobytes per second during this
interval for the mirror disk DECIMAL(9,1) INPUT_KB_PER_SEC_MIR
Output kilobytes per second during
this interval for the mirror disk DECIMAL(9,1) OUTPUT_KB_PER_SEC_MIR
Timestamp, in Universal Coordinated
Time, when the measurement was
submitted to the Repository TIMESTAMP(6) SUBMIT_TS_UTC
Timestamp, in Local Civil Time, when
the measurement was stored in the
Repository TIMESTAMP(6) UPDATE_TS
Minutes behind or ahead of UTC (can
be a positive or negative number) INTERVAL MINUTE(3) UTC_BIAS
EMS Events
This view provides access to information collected from the error event logs. Events from these
logs are available through this single view and you can use SQL to run queries against the
information collected. Refer to
Appendix A: “Sample Queries for Event Information” (page 67)
for sample queries that you can use.
VIEW NEO.HP_METRICS.EVENTS_VW1
Character columns use ISO88591 or UCS2 encoding, as appropriate to the Neoview platform
configuration. If the platform is UCS2 or SJIS, all character columns are created with CHARACTER
SET UCS2. If the platform is ISO88591, all CHAR columns are created with CHARACTER SET
ISO88591.
The primary key for EVENTS_VW1 field definition is LOG_TIMESTAMP_LCT, SEGMENT,
COLLECTOR, GENERATED_TIMESTAMP_UTC, and SEQ_NUMBER.
EMS Events 45