HP Neoview Release 2.4 Software - Manual (Page 53)

Table 3-9 DISK_STATS_V1 Field Definitions (continued)
Description Data Type Field Name
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 (page 73) 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.
Table 3-10 EVENTS_VW1 Field Definitions
Description Data Type Field Name
Primary Key
Timestamp, in Local Civil Time,
indicating when the event was
placed in the EMS log.
TIMESTAMP(6) LOG_TIMESTAMP_LCT
Primary Key
Name of the segment where
this event was logged. This
column always uses the
ISO88591 character set.
CHAR(8) SEGMENT
Primary Key
The name of the EMS collector
that logged this event. This
column always uses the
ISO88591 character set.
CHAR(8) COLLECTOR
Primary Key
Timestamp, in Coordinated
Universal Time, indicating
when the event was generated.
TIMESTAMP(6) GENERATED_TIMESTAMP_UTC
EMS Events 53