HP Neoview Release 2.5 Software - Manual (Page 87)

D 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 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”
(page 89) .
• 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
“Space Management
Views and Sample Query Views for Space Management” (page 47) .
• New sample query views for space management. See “Sample Query Views for Space
Management” (page 54) .
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
Appendix A: “Sample Queries for Event
Information” (page 67) 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 “Pre-R2.5 Query Statistics Views” (page 89) 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 “History of Field Changes for Repository” (page 131) and moved the Repository
history from “Repository Views” (page 19) 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.
New and Changed Information in Previous Editions 87