HP Neoview Release 2.3 Software - Manual (Page 15)

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 new view introduced as a
standard feature in Repository 2.3 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.
• 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 executor processes spawned by a particular
NDCS 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.
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
components and present some similar information but are typically used for slightly different
purposes:
• You use the Dashboard client to monitor queries and system resources on the Neoview
platform and to reveal, as soon as possible, if some aspect of system performance is outside
an acceptable range. The Dashboard client is a graphical user interface (GUI) that displays
current and recent data on color-coded graphs and accompanying grids. It includes a
Command and Control facility with which you can kill a running query.
• You use Repository queries to study patterns of resource utilization over time, for example
to find out how many queries from each of several data sources occurred during specific
time intervals.
Runtime statistics for queries are synchronized in the two products; in fact, the data collection
interval is configured in the Dashboard. Similarly, much of the data available for Tables and
Disk entities is initially obtained by statistics gathering processes (SGPs) in the Dashboard, and
the Dashboard configuration affects which Tables and Disks are represented in the Repository.
Repository Features and Interfaces 15