Hp Neoview Release 2.4 Software Manual de usuario descargar pdf (Pagina 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 Appendix A (page 73) 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 Appendix C (page 85) 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 Appendix D (page 117) and moved the Repository history from Chapter 3 (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.

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

1 2 ... 78 79 80 81 82 83 84 85 86 87 88 ... 127 128

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.4 Software Manual de usuario Pagina 83

Comentarios a estos manuales

Relacionado con productos y manuales para Software Hp Neoview Release 2.4 Software