beautypg.com

Disk statistics, View neo.hp_metrics.disk_stats_v1, Disk_stats_v1 field definitions – HP Neoview Release 2.3 Software User Manual

Page 54

background image

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