HP Neoview Release 2.3 Software - Manual (Page 53)

Table 3-10 TABLE_STATS_V2 and TABLE_STATS_DETAIL_V2 Field Definitions (continued)
Description Data Type Field Name
Name of the catalog in which the
object (e.g., the table) is stored CHAR(128) or NCHAR(128) CATALOG_NAME
Name of applicable schema for
the object (e.g., the table). CHAR(128) or NCHAR(128) SCHEMA_NAME
Name of the table, index, or
materialized view. CHAR(128) or NCHAR(128) OBJECT_NAME
Namespace in which the object
is visible, currently: ‘TABLE' CHAR(22) or NCHAR(22) OBJECT_NAME_SPACE
Kind of object, one of: ‘TABLE’
‘MAT VIEW’ or ‘_’ CHAR(22) or NCHAR(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 reorganization
status is COMPLETED, the
object will no longer be
monitored after fifteen minutes. CHAR(16) or NCHAR(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
Table Statistics 53