New and changed information in previous editions – HP Neoview Release 2.4 Software User Manual
Page 83
B History of New and Changed Information in Previous
Releases of the Repository
New and Changed Information in Previous Editions
The Release 2.4 Service Pack 1 (SP1) edition of this manual includes the following new and
changed information:
•
Data retention times were changed. See
“Configuring Retention Times for Data” (page 17)
.
•
Removed references to NCHAR and NCHAR VARYING.
•
Added a new view for accessing data from error event logs:
NEO.HP_METRICS.EVENTS_VW1, and
with sample queries to
obtain reports about these events.
•
Added two new views for accessing all query statistics:
— QUERY_STATS_VW1 – shows all available statistics for a query in a single row for each
execution of that query.
— SQL_TEXT_VW1 – stores the complete SQL text for queries that are longer than 254
characters.
A maximum of 16000 characters of SQL text can be stored in each of the multiple rows
in this view. The first 254 characters of SQL text are also included in one of the fields
in QUERY_STATS_VW1. When the SQL text for a query exceeds 254 characters, the
entire query text is stored in SQL_TEXT_VW1.
•
Added
and moved three views to it. These views currently exist on
the Neoview platform only so that existing queries will succeed. You can use these views
to obtain current query statistics. However, you are encouraged to update your queries to
use the new views, QUERY_STATS_VW1 and SQL_TEXT_VW1, as soon as possible.
— ODBC_QUERY_STATS_V1
— ODBC_QUERY_STATS_V2
— QUERY_RUNTIME_STATS_V1
•
Added three views. They exist on the Neoview platform so that queries can access data from
R2.4 only. This data is static and will never be updated.
— ODBC_QUERY_STATS_V1_2400
— ODBC_QUERY_STATS_V2_2400
— QUERY_RUNTIME_STATS_V1_2400
•
Added
and moved the Repository history from
to this appendix.
•
Removed new and changed manual information for previous editions to its own section,
leaving
“New and Changed Information in This Edition” (page 9)
for the current edition
only.
The R2.4 edition of this manual included the following new and changed information:
•
Clarify and correct text related to space and heap.
•
Miscellaneous other corrections and clarifications.
The R2.3 edition of this manual included the following new and changed information:
•
Description of Query Runtime Statistics as a standard feature, and enhancements to the
view that provides access to the data.
•
Description of the Disk entity and views that provide metric information for Disks.
•
Updates to reflect enhancements in the gathering of Table statistics.
•
Notes on support for alternative (Japan Shift-JIS and Unicode) character sets, where
applicable.
•
Naming changes to reflect the catalog and schema within which Repository views are defined.
The new catalog name is NEO; the new schema name is HP_METRICS.
New and Changed Information in Previous Editions
83