Neoview Repository User Guide (R2.4 SP1)

Table C-6 Field Name Mapping from TABLE_STATS_V1 to TABLE_STATS_V2 (continued)
Change in TABLE_STATS_V2Field Name in TABLE_STATS_V1
UPDATE_STATS_RUNNING_TSUPDATE_STATS_RUNNING_DATE and
UPDATE_STATS_RUNNING_TIME
METRIC_SUBMITTED_TS_UTCENTRY_DATE_UTC and ENTRY_TIME_UTC
UPDATE_TSUPDATE_DATE and UPDATE_TIME
Now has datatype VARCHAR(1740) and includes a
cumulative list of columns that have missing statistics
MISSING_STATS
Now defined as VARCHAR(1024)REPAIR_ACTION
No longer present in the viewMISSING_STATS_SEQ_NUM
No longer present in the viewMISSING_STATS_SEQ_SIZE
No longer present in the viewREPAIR_ACTION_SEQ_NUM
No longer present in the viewREPAIR_ACTION_SEQ_SIZE
No longer present in the viewMETRIC_SOURCE
LAST_REORG_TS is new in Repository 2.3.—
REORG_STATUS is new in Repository 2.3.—
MISSING_STATS_COUNT is new in Repository 2.3.—
Summary of Changes For Repository 2.4 SP1
These changes have been made to views between Repository 2.4 and Repository 2.4 SP1. If you
have already modified queries to reflect the new views in Repository 2.4 SP1, ignore this section.
New Repository View For Accessing Error Event Information
EVENTS_VW1 is a new Repository view to access error event information. Use SQL to query
this information and easily create reports that show you how these events are occurring across
the platform.
Repository View Changes For Easy Access to Query Statistics
These view changes allow access to query statistics without having to join rows or use multiple
views.
• Two new views access all query data:
— “VIEW NEO.HP_METRICS.QUERY_STATS_VW1” (page 22)
— “VIEW NEO.HP_METRICS.SQL_TEXT_VW1” (page 34)
• Three views allow you to access R2.4 Repository data. This data remains on the Neoview
platform, but does not change.
— “VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V1_2400” (page 36)
— “VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V2_2400” (page 39)
— “VIEW NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1_2400” (page 42)
• Three views are no longer used. For this release, these views provide access to current data
so that pre-SP1 queries continue to work:
— NEO.HP_METRICS.ODBC_QUERY_STATS_V1
— NEO.HP_METRICS.ODBC_QUERY_STATS_V2
— NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1
Some fields are not available in this release. If you run a query against these views a NULL
value is returned for these fields.
118 History of Changes for Repository