HP Neoview Release 2.4 Software User Manual
Page 48
•
TABLE_STATS_V2 provides the most recently collected data for each monitored object.
Thus, the view includes only one row per monitored table or materialized view.
•
TABLE_STATS_DETAIL_V2 presents all the data collected for the table or materialized view
since it began to be monitored. The view provides a row for each in condition reported by
the table monitoring process. Thus, the view includes one row for every data collection
interval.
For example, the following report could result from a query of TABLE_STATS_DETAIL_V2.
FIRST_SUBMIT_TS LATEST_SUBMIT_TS OBJECT_NAME MON_STATUS MISSING_STATS
-------------------------- -------------------------- ------------------------------ ---------- ---------
2007-10-11 10:03:01.000029 2007-10-11 10:03:01.000029 NEO.SCHEMA1.TABLE1 Up
SEGMENT_ID (2),DISK_NAME (1),(SEGMENT_ID, DISK_NAME) (1)
2007-10-11 10:04:00.992523 2007-10-11 11:25:00.995953 NEO.SCHEMA1.TABLE1 Up
(SEGMENT_ID, DISK_NAME) (1)
2007-10-11 11:26:00.991639 2007-10-11 11:31:01.00082 NEO.SCHEMA1.TABLE1 Dropped
-
2007-10-11 11:32:00.99343 2007-10-11 11:32:00.99343 NEO.SCHEMA1.TABLE1 Removed
A report on the same object from TABLE_STATS_V2 would show only the most recent information
about the object:
FIRST_SUBMIT_TS LATEST_SUBMIT_TS OBJECT_NAME MON_STATUS MISSING_STATS
-------------------------- -------------------------- ------------------------------ ---------- ---------
2007-10-11 11:32:00.99343 2007-10-11 11:32:00.99343 NEO.SCHEMA1.TABLE1 Removed
The Repository gets table data from the Neoview Management Dashboard, which begins to
monitor a table in two circumstances:
•
Neoview event services generate runtime warnings when a table has missing statistics. Any
table that is the subject of such a warning is monitored until fifteen minutes after the statistics
are updated.
•
The Dashboard Table SGP gathers information about monitored tables that have missing
or obsolete statistics or that need reorganization. HP Support can customize the Dashboard
configuration to specify which tables are monitored.
To update outdated statistics, perform an Update Statistics operation on the table.
VIEW NEO.HP_METRICS.TABLE_STATS_V2 and VIEW
NEO.HP_METRICS.TABLE_STATS_DETAIL_V2
These views will not show any data because the data is not available from the metrics provider
(Dashboard).
Character columns use ISO88591 or UCS2 encoding, as appropriate to the Neoview platform
configuration. If the platform is UCS2 or SJIS, all character columns are created with CHARACTER
SET UCS2. If the platform is ISO88591, all CHAR columns are created with CHARACTER SET
ISO88591.
The primary key for these views is CATALOG_NAME, SCHEMA_NAME, OBJECT_NAME,
OBJECT_NAME_SPACE,L FIRST_SUBMIT_TS, and LATEST_SUBMIT_TS.
Table 3-8 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)
CATALOG_NAME
48
Repository Views