Enabling capture of session data – HP Neoview Release 2.3 Software User Manual
Page 18
If you’ve written queries using views defined in Release 2.1, modify them to use the corresponding
views described in this document. The Release 2.1 (deprecated) views are no longer available in
Release 2.3. Differences between Release 2.1 and more recently defined views include:
•
Naming consistent with the terminology used in Neoview user documentation.
•
ANSI SQL Date and Time columns, which allow ANSI SQL standard date and time
computations.
•
Support for new metrics including Query Runtime Statistics, Table statistics, and Disk
statistics.
The Query Runtime Statistics feature is especially useful for monitoring queries that run for long
periods of time.
For a summary of field definition changes from Repository 2.1 to Repository 2.2, see
of Field Definition Changes from Repository 2.1” (page 57)
.
Similarly, if you've written queries using views defined in Repository 2.2, you must modify them
to use views described in this document:
•
Where your queries refer to catalog and schema MATRIX.MANAGEABILITY, modify them
to refer to NEO.HP_METRICS,
•
If a query uses data from the view TABLE_STATS_V1, modify it to use TABLE_STATS_V2
or TABLE_STATS_DETAIL_V2, using field definitions defined for these enhanced views.
•
If a query uses data from the view QUERY_RUNTIME_STATS_V1, you need not change
the name of the view, other than the catalog and schema names, but you might need to
modify your query in other ways to accommodate changes in field definitions.
For a summary of changes in field definitions from Repository 2.2 to Repository 2.3, see
of Field Definition Changes from Repository 2.2” (page 59)
.
Obtaining Repository Documentation and Prepackaged Queries
This document is available on the Business Intelligence Solutions page of docs.hp.com:
Beginning in Release 2.3, prepackaged queries against the Repository are distributed as part of
the Neoview Reports product.
Enabling Capture of Session Data
To allow session and query data to be captured and stored in the Repository, ensure that the
following Resource Statistics tab boxes are checked in the DB Admin data source configuration
for all data sources:
Neoview DB Admin -> Connectivity -> Data Source Configurations -> data
source name -> Resource Statistics
18
Getting Started with Repository 2.3