HP Neoview Release 2.4 Software - Manual (Page 50)

Table 3-8 TABLE_STATS_V2 and TABLE_STATS_DETAIL_V2 Field Definitions (continued)
Description Data Type Field Name
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) 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) 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.
Table 3-9 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
Process identification number of the
disk process for this volume SMALLINT UNSIGNED PIN
Neoview platform segment name CHAR(8) SEGMENT_NAME
Duration of the sample interval INTERVAL SECOND(12,6) SAMPLE_ELAPSED_TIME
Percentage of disk space currently in
use DECIMAL(6,1) FULL_PCT
Available disk space, in megabytes DECIMAL(12,1) AVAILABLE_SPACE
Total capacity of this volume, in
megabytes INTEGER CAPACITY
50 Repository Views