HP Neoview Release 2.5 Software - Manual (Page 84)

Table C-3 TABLE_STATS_V2 and TABLE_STATS_DETAIL_V2 Field Definitions (continued)
Description Data Type Field Name
Namespace in which the object is visible,
currently: ‘TABLE' CHAR(22) OBJECT_NAME_SPACE
Kind of object, one of: ‘TABLE’ ‘MAT VIEW’
or ‘_’ CHAR(22) OBJECT_TYPE
“Up” means the table or materialized view
is being monitored. “Dropped” means that
the table or materialized view was dropped
or renamed, and no other object with the
same name was created. “Removed” means
the table or materialized view is no longer
being monitored and will stop appearing in
displays 15 minutes after that change in
status. “NoTable” means that a table was
specified in the Dashboard server
configuration as a monitored object, but no
table of the specified name exists. If all
missing statistics for an automatically
monitored object are updated and
reorganization status is COMPLETED, the
object will no longer be monitored after
fifteen minutes. CHAR(16) MONITOR_STATUS_TXT
Offset in minutes from Coordinated
Universal Time for the local system at time
this record was written. The maximum offset
is 720 minutes. The value can be positive or
negative. INTERVAL
MINUTE (3) UTC_BIAS
Timestamp, in Local Civil Time, when
update statistics was first run on the table.
If there is no HISTOGRAMS table or no row
for this object, the value in this field is NULL. TIMESTAMP(6) MIN_STATS_TS
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) REORG_STATUS
Total count of missing statistics events for
this object. INTEGER MISSING_STATS_COUNT
84 Repository Views Disabled by Default