HP Neoview Release 2.5 Software - Manual (Page 10)

• Created new appendix for STATEMENT_TYPE field of QUERY_STATS_VW2. See
Appendix B: “STATEMENT_TYPE Field” (page 73) .
• Moved Processing statistics (including the PROCESS_STATS_V1 AND
PROCESS_AGGR_LEVEL1_STATS_V1 views) and Table statistics (including the
TABLE_STATS_V2 and TABLE_STATS_DETAIL_V2 views) to new
Appendix C: “Repository
Views Disabled by Default” (page 75) .
• Moved QUERY_STATS_V1 view to Appendix E: “Pre-R2.5 Query Statistics Views” (page 89) .
Document Organization
This document is organized as follows:
Chapter 1: Introduction
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.
Chapter 3: Repository Views
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.
Appendix A: Sample Queries for Event Information
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.
Appendix B: STATEMENT_TYPE Field
Use this appendix to see the possible values for the STATEMENT_TYPE fields in the
QUERY_STATS_VW2 view.
Appendix C: Repository Views Disabled by Default
Use this appendix to learn about views that are disabled by default. These views include
Process Statistics and Table Statistics.
Appendix D: History of New and Changed Information in Previous Releases of the Repository
Use this appendix to learn about the history of new and changed information in the Repository.
Appendix E: Pre-R2.5 Query Statistics Views
Use this appendix to learn about the query statistics views before R2.5. Current data is
available through these views. However, some fields now return NULL values and you must
use the “two rows per query” semantics for query statistics.
Appendix F: History of Field Changes for Repository
Use this appendix to review the changes that have been made to the fields in the Repository,
beginning with Release 2.2 to the current release.
Glossary
Use the glossary to find the meanings of various terms used in this document.
Notation Conventions
General Syntax Notation
This list summarizes the notation conventions for syntax presentation in this manual.
10