HP Neoview Release 2.4 Software - Manual (Page 55)

Table 3-10 TABLE_STATS_V2 and TABLE_STATS_DETAIL_V2 Field Definitions
Description Data Type Field Name
Timestamp in Local Civil Time
when the data in this record was
first submitted to the Repository. TIMESTAMP(6) FIRST_SUBMIT_TS
Timestamp in Local Civil Time
when the data in this record was
most recently submitted to the
Repository. TIMESTAMP(6) LATEST_SUBMIT_TS
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
Table Statistics 55