HP Neoview Release 2.4 Software - Manual (Page 56)

Table 3-10 TABLE_STATS_V2 and TABLE_STATS_DETAIL_V2 Field Definitions (continued)
Description Data Type Field Name
Timestamp, in Local Civil Time,
of the most recent update
statistics operation on the table.
If there is no HISTOGRAMS
table or no row for this object,
the value in this field is NULL. TIMESTAMP(6) MAX_STATS_TS
Number of times update
statistics has run on the table. SMALLINT UNSIGNED DISTINCT_STATS
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.
The primary key for DISK_STATS_V1 field definition is SUBMIT_TS, SEGMENT_ID, and
VOLUME_NAME.
56 Repository Views