Disk statistics, View neo.hp_metrics.disk_stats_v1, Disk_stats_v1 field definitions – HP Neoview Release 2.3 Software User Manual
Page 54
Table 3-10 TABLE_STATS_V2 and TABLE_STATS_DETAIL_V2 Field Definitions (continued)
Description
Data Type
Field Name
If update statistics is currently
running, start time for that
operation, in Local Civil Time.
TIMESTAMP(6)
UPDATE_STATS_RUNNING_TS
Time at which the last
reorganization of the table
occurred.
TIMESTAMP(6)
LAST_REORG_TS
COMPLETED, IN_PROGRESS,
or NONE
CHAR(11) or NCHAR(11)
REORG_STATUS
Total count of missing statistics
events for this object.
INTEGER
MISSING_STATS_COUNT
Cumulative list of columns for
which statistics are missing, or
“-” if the data is not the result of
a runtime warning. Value is a
comma-separated list in which
each member has the form
column
(number) or (column,
column
)(number), where
column
is a column name, and
number
is the corresponding
number of missing statistics
warnings. If no columns with
missing statistics have been
identified so far, the value in this
field is NULL.
VARCHAR(1740) or NCHAR
VARYING(1740)
MISSING_STATS
Proposed repair action (update
statistics), or “-” if the data is not
the result of a runtime warning.
If no columns with missing
statistics have been identified so
far, the value in this field is
NULL.
VARCHAR(1024) or NCHAR
VARYING(1024)
REPAIR_ACTION
Disk Statistics
The view DISK_STATS_V1 provides access to data describing the availability, utilization, and
performance of disk volumes. The sampling interval and the set of disks represented in the view
are determined by the Neoview Management Dashboard configuration.
VIEW NEO.HP_METRICS.DISK_STATS_V1
In this view, all CHARACTER columns use ISO88591 encoding, regardless of the underlying
Neoview platform configuration.
Table 3-11 DISK_STATS_V1 Field Definitions
Description
Data Type
Field Name
Timestamp, in Local Civil Time,
indicating when the measurement was
submitted to the Repository
TIMESTAMP(6)
SUBMIT_TS
Neoview platform segment number
SMALLINT UNSIGNED
SEGMENT_ID
Logical disk volume name
CHAR(8)
VOLUME_NAME
Primary processing node number of
the disk process for this volume
SMALLINT UNSIGNED
NODE_ID
54
Repository Views