Hp Neoview Release 2.5 Software Bedienungsanleitung Seite 119
- Seite / 142
- Inhaltsverzeichnis
- LESEZEICHEN
Bewertet. / 5. Basierend auf Kundenbewertungen
Table E-6 ODBC_QUERY_STATS_V1 Field Definitions (continued)
DescriptionData TypeField Name
Compiler-provided value, one of:
SQL_SELECT_UNIQUE,
SQL_SELECT_NON_UNIQUE
SQL_INSERT_UNIQUE,
SQL_INSERT_NON_UNIQUE,
SQL_UPDATE_UNIQUE,
SQL_UPDATE_NON_UNIQUE,
SQL_DELETE_UNIQUE,
SQL_DELETE_NON_UNIQUE,
SQL_CONTROL,
SQL_SET_TRANSACTION,
SQL_SET_CATALOG,
SQL_SET_SCHEMA, SQL_OTHER,
SQL_UNKNOWN,
SQL_CALL_NO_RESULT_SETS,
SQL_CALL_WITH_RESULT_SETS,
SQL_SP_RESULT_SET,
SQL_NOT_SUPPORTED. For
definitions of SQL statement types,
see the Neoview SQL Reference
Manual. For example, to find
information about
SQL_SET_TRANSACTION, look up
the SET TRANSACTION statement
in the Neoview SQL Reference Manual.
The suffix _UNIQUE indicates that
the statement operates on a single
row. The suffix _NON_UNIQUE
indicates that the statement could
operate on multiple rows. In the
START row for an ExecuteDirect
query, the value of this field is always
SQL_UNKNOWN; in the END row,
it has its proper value.
CHARACTER(36)STATEMENT_TYPE
A unique ID for the query, beginning
with the string “MXID” and
including, among other elements a
unique query number, delimited by
underscores, and an ODBC-generated
statement ID. If an error occurred
before the query launched, the value
in this field is the text <EMPTY>.
VARCHAR(160)QUERY_ID
Text of the query. If the length
exceeds 3200 bytes, the Repository
will contain multiple rows, with
ascending values in the
SEQUENCE_NUM field.
VARCHAR(3200)SQL_TEXT
VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V2
For ODBC/JDBC data—not query runtime statistics—the Repository stores a start and end row
for each ODBC query (active or historical). To access the rows separately, use the
ODBC_QUERY_STATS_V1 view.
In contrast, the view ODBC_QUERY_STATS_V2 converts this information so that a single row
provides complete information about the start and end of a query for COMPLETE queries. You
can also use this view to extract UNTERMINATED queries and MULTIROW queries.
UNTERMINATED queries are queries that are still active (INCOMPLETE) or that terminated
abnormally (ERRTERMINATION). MULTIROW rows provide the complete query text of queries
whose length exceeds 3200 bytes. The QUERY_TEXT_IS_MULTIROW column also designates
multirow queries.
Query Statistics for Release 2.4 119
- 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
Verwandte Produkte und Handbücher für Software Hp Neoview Release 2.5 Software
Software Hp Smart Update Manager Bedienungsanleitung
(130 Seiten)
(130 Seiten)
Software Hp Access Control Bedienungsanleitung
(14 Seiten)
(14 Seiten)
(81 Seiten)Whirlpool R 24 S (EU) podręczniki
Instrukcje obsługi i podręczniki użytkownika dla Lodówki Whirlpool R 24 S (EU).
Dostarczamy 1 pdf podręczników Whirlpool R 24 S (EU) do pobrania za darmo według typów dokumentów: Instrukcja Obsługi
Kommentare zu diesen Handbüchern