HP Neoview Release 2.4 Software - Manual (Page 54)

Table Statistics
The Repository includes two views that provide access to data about tables or materialized views
whose histogram statistics are missing or out of date. The views have identical column definitions
but satisfy different purposes:
• 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 in these views use ISO88591 or UCS2 encoding, as appropriate to the Neoview
platform configuration. In the following table:
• If a data type is given as CHAR or NCHAR, then CHAR applies if the character set is
ISO88591, and NCHAR applies if the character set is UCS2.
• If a data type is given as VARCHAR or NCHAR VARYING, the VARCHAR applies if the
character set is ISO88591, and NCHAR VARYING applies if the character set is UCS2.
The primary key for these views is CATALOG_NAME, SCHEMA_NAME, OBJECT_NAME,
OBJECT_NAME_SPACE,L FIRST_SUBMIT_TS, and LATEST_SUBMIT_TS.
54 Repository Views