Hp Neoview Release 2.5 Software Bedienungsanleitung PDF herunterladen (Seite 132)

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 89)

— “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 102)

— “VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V2_2400” (page 105)

— “VIEW NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1_2400” (page 108)

• 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 F-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

PINPINSEQUENCE_NUM

MASTER_BUSYUSER_IDMETRIC_CLASS_ID

NODE_BUSY_FOR_BUSIEST_ESPQUERY_TEXT_IS_MULTIROWMETRIC_CLASS_VERSION

PCT_BUSY_ALL_PROCESSESTOTAL_EXECUTESSEQUENCE_SIZE

BUSIEST_ESP_NODETOTAL_EXECUTES

BUSIEST_ESP_PINPIN

BUSY_ESP_SEGMENTUSER_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

132 History of Field Changes for Repository

1 2 ... 127 128 129 130 131 132 133 134 135 136 137 ... 141 142

Kommentare zu diesen Handbüchern

Keine Kommentare

Hp Neoview Release 2.5 Software Bedienungsanleitung Seite 132

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software Hp Neoview Release 2.5 Software