HP Neoview Release 2.4 Software - Manual (Page 118)

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 19)
— “VIEW NEO.HP_METRICS.SQL_TEXT_VW1” (page 32)
• 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 86)
— “VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V2_2400” (page 89)
— “VIEW NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1_2400” (page 92)
• 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.
Table D-1 Fields Not Available in Repository 2.4 SP1 Views ODBC_QUERY_STATS_V1,
ODBC_QUERY_STATS_V2, and QUERY_RUNTIME_STATS_V1
Field Unavailable in
QUERY_RUNTIME_STATS_V1 Field Unavailable in
ODBC_QUERY_STATS_V2 Field Unavailable in
ODBC_QUERY_STATS_V1
PIN PIN SEQUENCE_NUM
MASTER_BUSY USER_ID METRIC_CLASS_ID
NODE_BUSY_FOR_BUSIEST_ESP QUERY_TEXT_IS_MULTIROW METRIC_CLASS_VERSION
PCT_BUSY_ALL_PROCESSES TOTAL_EXECUTES SEQUENCE_SIZE
BUSIEST_ESP_NODE TOTAL_EXECUTES
BUSIEST_ESP_PIN PIN
BUSY_ESP_SEGMENT USER_ID
BUSY_THRESHOLD
PCT_NODE_BUSY_ALL_ESPS
PCT_TOT_BUSY_FOR_INTERVAL
ESP_BUSY_FOR_INTERVAL
MASTER_BUSY_FOR_INTERVAL
MIN_PRIORITY_ESP
EST_PARALLELISM
118 History of Field Changes for Repository