HP Neoview Release 2.4 Software - Manual (Page 13)

1 Introduction
Repository Features and Interfaces
The Neoview Manageability Repository is a Neoview SQL database and set of programs that
automatically collect and store statistics and other information about the following entities on a
Neoview platform:
• Queries initiated through ODBC and JDBC. Certain data about queries is available from the
time the query starts; other data becomes available only after the query is complete.
• Queries managed by Workload Management Services (WMS). A view included as a standard
feature in Repository 2.4 provides runtime statistics for database statements as they execute.
The interval for collecting data while the query runs is set in the Neoview Management
Dashboard configuration (performed by HP Support) but can be as long as two minutes.
• Processing nodes (CPUs). Information about processing nodes is collected from the Neoview
platform every five minutes.
• Table statistics. A statistics gathering and event monitoring process in the Neoview
Management Dashboard captures information about tables with missing or old histogram
statistics. Two Repository views provide information about missing or obsolete statistics
and recommended repair actions.
• Disks. Information about disk availability and performance is collected from the Neoview
platform once per minute, by default.
• Optional processes involved in query execution. Process statistics gathering is disabled by
default, but if you enable this feature, the information is collected from the Neoview platform
every five minutes. Different views provide access to information about individual processes
and sets of processes of the same type, for example all query execution processes started by
a specific query (NDCS connectivity server process). The Repository data collector process
is also monitored. Aggregates for sets of related processes are computed every five minutes
with a 15-minute delay; thus, aggregate data becomes available from the Repository 15
minutes after the end of the sampling interval.
Process collectors should not be turned on because they place a load on the platform.
NOTE: As part of the retirement of the process statistics collectors, the collectors are not
installed or configured on systems configured with Unicode characters sets.
The Repository is used to store historical information that the DBA can access to see patterns of
queries which were run on the Neoview platform. Some examples of the resource information
that can be obtained from the Repository includes:
• Platform CPU (Node) usage by time (hourly, daily, and distribution by segment)
• Platform disk space usage
• Information on queries run by specific users, applications, client PCs, type of queries run at
which time, the number of queries run
More information and sample queries are available from within the Neoview Reports product.
Any database administrator (ROLE.DBA) can issue queries against the Repository, using Neoview
Command Interface or another standard SQL interface, and can grant other users access to the
Repository. Prepackaged queries are also available for display in the Neoview Reports tool,
described in the Neoview Reports Online Help.
The Repository is related to another Neoview manageability product, called the Neoview
Management Dashboard. That product is described in the Neoview Management Dashboard Client
Guide for Database Administrators. The Dashboard and Repository use some of the same runtime
Repository Features and Interfaces 13