About this document, Supported release version updates (rvus), Intended audience – HP Neoview Release 2.4 Software User Manual
Page 9: New and changed information in this edition, Document organization
About This Document
This document describes the views supported by the Neoview Manageability Repository, a
Neoview SQL database and set of programs that collect and store statistics and other information
about queries, query sessions, tables, disks, processing nodes, and (optionally) selected processes
involved in query execution on a Neoview platform.
Supported Release Version Updates (RVUs)
This manual supports N02.04 SP2 and subsequent N-series RVUs until otherwise indicated in a
replacement publication.
Intended Audience
This document is intended for Neoview platform administrators, database administrators, and
other users interested in evaluating query performance and resource utilization on a Neoview
platform. Familiarity with Neoview SQL is a prerequisite.
New and Changed Information in This Edition
The Release 2.4 Service Pack 2 (SP2) edition of this manual includes the following new and
changed information:
•
New fields in QUERY_STATS_VW1: DISK_PROCESS_BUSY_TIME_SEC and
MASTER_EXECUTION_TIME_SEC. See
“VIEW NEO.HP_METRICS.QUERY_STATS_VW1”
•
New fields in SQL_TEXT_VW1: EXEC_START_LCT_TS and EXEC_START_UTC_TS. See
“VIEW NEO.HP_METRICS.SQL_TEXT_VW1” (page 32)
.
•
New space management views: VIEW
NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1 and VIEW
NEO.HP_METRICS.SPACE_PARTITION_DETAIL_HISTORY_VW1. See
Views and Sample Query Views for Space Management” (page 55)
•
New sample query views for space management. See
Document Organization
This document is organized as follows:
Use this chapter to learn about the Repository and related Neoview software products.
Chapter 2: Getting Started with Repository
Use this chapter to find how to obtain and install the Repository software, enable capture of
session data, and configure retention times for data.
Use this chapter to learn about the available Repository views, including the meanings of
statistics and other data available through the views.
Chapter 4: Examples and Guidelines for Creating Repository Queries
Use this chapter to see several simple examples of Repository queries and to learn about
guidelines for creating your own queries.
Use this appendix to see sample Repository queries of error and event information on the
Neoview platform. You can use these sample queries or create your own queries following
the format in the examples.
Supported Release Version Updates (RVUs)
9