Hp Neoview Release 2.4 Software Manual de usuario descargar pdf (Pagina 104)

Table C-5 ODBC_QUERY_STATS_V1 Field Definitions (continued)

DescriptionData TypeField Name

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.

This table indicates which fields are present for completed and incomplete queries. The source

of data fields indicates whether the value is collected at the start of the query or at the end. Unless

indicated here, field descriptions are those provided above for ODBC_QUERY_STATS_V1.

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 ODBC_QUERY_STATS_V2 fields is SEGMENT_ID, NODE_ID,

SEQUENCE_NUM and the date/time fields (QUERY_START_DATETIME_UTC and the other

date fields.

Table C-6 ODBC_QUERY_STATS_V2 Fields

Source and NotesData TypeIncomplete QueriesComplete Queries

STARTCHAR(10) or

NCHAR(10)

SEGMENT_NAMESEGMENT_NAME

STARTINT

UNSIGNED

SEGMENT_IDSEGMENT_ID

STARTINT

UNSIGNED

NODE_IDNODE_ID

Derived from

CPU, PIN

INT

UNSIGNED

PINPIN

STARTSMALLINT

UNSIGNED

START_PRIORITY

STARTCHAR(18)PROCESS_NAMEPROCESS_NAME

STARTCHAR(108)SESSION_IDSESSION_ID

104 Pre-R2.4 SP2 Query Statistics Views

1 2 ... 99 100 101 102 103 104 105 106 107 108 109 ... 127 128

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.4 Software Manual de usuario Pagina 104

Comentarios a estos manuales

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