Neoview Repository User Guide (R2.4 SP1)

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:
• Use the Neoview Performance Analyzer (NPA) client to monitor queries and system resources
on the Neoview platform and to reveal, as soon as possible, whether some aspect of system
performance is outside an acceptable range. NPA is the recommended interface for viewing
running queries, and provides a way to view, terminate, suspend, or resume queries. You
can also use the HPDM system monitor and System Offender features to monitor the platform
in real-time.
• 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.
The data available for Tables and Disk entities is initially obtained by statistics gathering processes
(SGPs) in the Dashboard, and the Dashboard configuration affects whether table and disk data
is stored in the Repository.
If any of the Table or Disk SPGs are turned off in Dashboard, there will be no data in the
Repository for the corresponding Repository entity. As the Repository receives all the data from
Dashboard for these entities, the configuration of Dashboard will affect the Repository.
NOTE: As of R 2.4 SP1, running query information is no longer available from the Repository.
Use the Neoview Performance Analyzer to monitor running queries on the Neoview platform.
Figure 1-1 illustrates, at a very high level, the architectural relationship and interfaces of the
Repository and the products with which it interacts. This manual describes only the user interface
of the Repository, which allows you to create and display the results of Repository queries on
any standard SQL interface. HP Support has access to additional tools for managing the Repository
configuration.
Figure 1-1 Neoview Repository and Related Products
18 Introduction