README for HP Neoview Release 2.4 Service Pack 1
The System Offender tab helps users identify the sources of runaway queries and offers
tools for gathering workload information. Users can display workload detail, process detail,
and children processes for a selected process. Only administrators (ROLE.DBA, super.services,
and super.super by default) can alter System Offender parameters, display Pstate information,
use the Pstate command, and cancel queries, but non-administrator users can use all other
System Offender features.
For more information, see the HPDM online help or the HP Database Manager (HPDM) User Guide.
NOTE: To connect to a Neoview platform, the HP Database Manager requires the HP ODBC
2.0 client driver for Windows. Download the HP ODBC 2.0 client driver from the HP software
download site and install it before running the HP Database Manager. For complete information
about installing HPDM, see the README for the HP Database Manager.
Neoview Repository
Three new Repository views improve the collection of these metrics:
Two new Repository views allow you to access compilation and execution (runtime) statistics
in one place without having to join rows or use multiple views:
• NEO.HP_METRICS.QUERY_STATS_VW1 provides access to all query statistics, including
new query statistics metrics
• NEO.HP_METRICS.SQL_TEXT_VW1 provides access to the full SQL query text if longer
than 254 bytes.
• Query statistics:
A new Repository view—NEO.HP_METRICS.EVENTS_VW1—allows you to use SQL to query
information collected from the event message logs. Events from these logs on all segments
are available through this single view.
• Event messages:
All data in the Repository is now stored for 30 days.
In Release 2.4 SP1, new query statistics data is collected in a new Repository table, which the
QUERY_STATS_VW1 and SQL_TEXT_VW1 access. Old query statistics data, which was collected
before Release 2.4 SP1 was installed, remains in the original Repository tables. To access the old
Repository data, use these Repository views:
• NEO.HP_METRICS.ODBC_QUERY_STATS_V1_2400
• NEO.HP_METRICS.ODBC_QUERY_STATS_V2_2400
• NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1_2400
NOTE: The old data displayed in those views will not be transferred to the new Repository
table and cleaned up. Also, the old Repository tables will no longer collect new data after Release
2.4 SP1 is installed. To remove old Repository data (and the tables that contain it), contact your
HP service provider.
For more information about those Repository views, see the Neoview Repository User Guide.
Neoview Workload Management Services (WMS)
The current software release introduces these new features and enhancements to Neoview WMS:
• The Neoview Performance Analysis Tools now include a point-and-click interface for
configuring WMS services and rules. For more information, see the Neoview Performance
Analysis Tools User Guide and the NPA Tools online help within the product.
• In previous software releases, when you hold executing queries, the QUERY_STATE of
those queries is HOLDING with a QUERY_SUBSTATE of SUSPENDED_BY_ADMIN. Now,
the QUERY_STATE of those queries is SUSPENDED with a QUERY_STATE of BY ADMIN.
• The RELEASE SERVICE command now generates this error message if you try to release a
service that is outside of its active time:
14