Hp Neoview Release 2.5 Software Manual de usuario Pagina 122
- Pagina / 142
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
Table E-7 ODBC_QUERY_STATS_V2 Fields (continued)
Source and NotesData TypeIncomplete QueriesComplete Queries
END, or NULL for
an incomplete
query
LARGEINTROWS_ACCESSED
END, or NULL for
an incomplete
query
LARGEINTROWS_RETRIEVED
END, or NULL for
an incomplete
query
LARGEINTNUM_ROWS_IUD
END, or NULL for
an incomplete
query
LARGEINTTOTAL_EXECUTES
STARTVARCHAR(3200)SQL_TEXT
NOTE: In both ODBC_QUERY_STATS_V1 and ODBC_QUERY_STATS_V2, the QUERY_ID
field contains the unique ID of the query unless an error occurs before the query is launched. In
this case, no query ID is assigned, and the corresponding field is populated with the value
<EMPTY>. The rest of the information pertaining to the query, including the error code, is stored
in the appropriate columns.
VIEW NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1
This view provides information collected while a query is running. The Repository obtains this
information through a statistics gathering process within the Neoview Management Dashboard.
Because statistics are updated as the query executes, you can use this view to monitor running
queries.
With regard to when query statistics will be present, a single row is written per query execution.
Thus, if the same query is executed 3 times, 3 rows will be present. If a query runs for a long time
(that is, longer than the configured data collection interval), the statistics for that query will be
updated at each data collection interval.
When compared with the other available views that provide information for queries, this one
contains many additional fields. Fields available only in this view are marked with asterisks (*)
in the list below.
Note that only queries managed by Neoview Workload Management Services are reflected in
this view. For information about the features and limitations of WMS, see the Neoview Workload
Management Services Guide.
Also note that query completion statistics are not guaranteed to be present in this view.
The interval for collecting data while a query runs is set in the Dashboard configuration. Contact
your HP Support representative for assistance in changing the configuration.
Character columns use ISO88591 or UCS2 encoding, as appropriate to the Neoview platform
configuration. If the platform is UCS2 or SJIS, all character columns are created with CHARACTER
SET UCS2. If the platform is ISO88591, all CHAR columns are created with CHARACTER SET
ISO88591.
The primary key for QUERY_RUNTIME_STATS_V1 field definitions is SEGMENT_ID, NODE_ID,
PIN, and SUBMIT_TS.
122 Pre-R2.5 Query Statistics Views
- HP Part Number: 611086-001 1
- Published: July 2010 1
- Table of Contents 3
- 4 Table of Contents 4
- Table of Contents 5 5
- List of Figures 6
- List of Tables 7
- List of Examples 8
- About This Document 9
- Document Organization 10
- Notation Conventions 10
- Notation Conventions 11 11
- Related Documentation 12
- Neoview Customer Library 13
- Publishing History 14
- HP Encourages Your Comments 14
- 1 Introduction 15
- 16 Introduction 16
- Installation 17
- Obtaining Prepackaged Queries 17
- Starting the Repository 17
- 3 Repository Views 19
- ODBC Session Data 33
- Processing Node Statistics 40
- Disk Statistics 42
- EMS Events 45
- Management 47
- SPACE_Q_CATALOG_SIZE_VW1 54
- SPACE_Q_DISK_FULL_VW1 55
- SPACE_Q_OBJECT_GROWTH_VW1 55
- SPACE_Q_PARTITION_FULL_VW1 56
- SPACE_Q_SYSTEM_DETAILS_VW1 56
- SPACE_Q_SYSTEM_TOTAL_SIZE_VW1 56
- SPACE_Q_TABLES_BY_SCHEMA_VW1 56
- SPACE_Q_TABLE_FULL_VW1 57
- SPACE_Q_TABLE_SIZE_VW1 57
- SPACE_Q_TOP_10_TABLE_SIZE_VW1 58
- Overview 59
- Sample Query Result 72
- B STATEMENT_TYPE Field 73
- Process Statistics 75
- Table Statistics 82
- Releases of the Repository 87
- Query Statistics for R2.4 SP2 89
- Query Statistics for R2.4 SP1 101
- New Fields in SQL_TEXT_VW1 131
- New Space Management Views 131
- New Fields in QUERY_STATS_VW1 131
- Glossary 139
Relacionado con productos y manuales para Software Hp Neoview Release 2.5 Software
Software Hp Smart Update Manager Manual de usuario
(130 paginas)
(130 paginas)
Software Hp ProLiant Support Pack Manual de usuario
(44 paginas)
(44 paginas)
Software Hp SmartStart-Software Manual de usuario
(29 paginas)
(29 paginas)
Software Hp Access Control Manual de usuario
(14 paginas)
(14 paginas)
Software Hp XC System 2.x Software Manual de usuario
(154 paginas)
(154 paginas)
Software Hp Smart Update Manager Manual de usuario
(86 paginas)
(86 paginas)
© 2020, manymanuals.es. Todos los derechos reservados | 0.029 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales