Hp Neoview Release 2.5 Software Manual de usuario Pagina 124
- Pagina / 142
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
Table E-8 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)
DescriptionData Type
Field Name (* means available only in
this view)
Node utilization for the Master
Executor for the last interval.
SMALLINT UNSIGNED NO
DEFAULT
MASTER_BUSY_FOR_INTERVAL*
Minimum priority this Master
Executor has had while executing.
SMALLINT UNSIGNED NO
DEFAULT
MIN_PRIORITY_ESP*
Estimated parallelism of the query,
computed as
BusyExecutorServerProcesses/Number
of processors * 100.
SMALLINT UNSIGNED NO
DEFAULT
EST_PARALLELISM*
Difference in minutes between the time
when WMS last refreshed statistics
from RMS. (REFRESH_TS value) and
the time when the Repository last
wrote this row (LAST_UPDATE_TS).
Indicates lag time, if any, between
WMS statistics and Repository
statistics.
INTERVAL MINUTE(6) NO
DEFAULT
LAG_ELAPSED_TIME*
Offset in minutes between Local Civil
Time and UTC when this record was
written.
INTERVAL MINUTE(3) NO
DEFAULT
UTC_BIAS
Repository internal. Identification
number of the Query Runtime
Statistics metric class (measurement)
in the Metric Class Registry.
INTEGER UNSIGNED NO
DEFAULT
METRIC_CLASS_ID
Repository internal. Internal version
number of the Query Runtime
Statistics metric (measurement) in the
Metric Class Registry.
INTEGER UNSIGNED NO
DEFAULT
METRIC_CLASS_VERSION
Repository internal.CHAR(10) NO DEFAULTMETRIC_CTRL
SQL error code, if any, returned in
response to this query. The value is 100
for completed SELECT, UPDATE, or
DELETE statements with actual end
statistics. The value is 0 for completed
INSERT queries or for uncompleted
queries. A negative number indicates
an execution-type error.
INTEGER SIGNED NO DEFAULTERROR_CODE
Number assigned to the query by
WMS. Value will be zero (0).
INTEGER SIGNED NO DEFAULTQUERY_INDEX*
Unique numeric ID for the service,
assigned by WMS. Corresponds to
SERVICE_NAME. Value will be (0).
INTEGER SIGNED NO DEFAULTSERVICE_INDEX*
Numeric form of the user ID, an
integer identifying the user.
INTEGER SIGNED NO DEFAULTUSER_ID
Total number of child Executor Server
Processes busy (as busy as or busier
than BUSY_THRESHOLD) during the
last interval.
INTEGER SIGNED NO DEFAULTNUM_ESPS_GT_THRESHOLD*
Total number of child Executor Server
Processes for the query.
INTEGER SIGNED NO DEFAULTNUM_CHILD_ESPS*
Total number of child Executor Server
Processes in a suspended state.
INTEGER SIGNED NO DEFAULTNUM_SUSPENDED_ESPS*
124 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.052 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales