HP Neoview Release 2.4 Software - Manual (Page 104)

Table C-5 ODBC_QUERY_STATS_V1 Field Definitions (continued)
Description Data Type Field 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 . 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 Notes Data Type Incomplete Queries Complete Queries
START CHAR(10) or
NCHAR(10) SEGMENT_NAME SEGMENT_NAME
START INT
UNSIGNED SEGMENT_ID SEGMENT_ID
START INT
UNSIGNED NODE_ID NODE_ID
Derived from
CPU, PIN INT
UNSIGNED PIN PIN
START SMALLINT
UNSIGNED START_PRIORITY
START CHAR(18) PROCESS_NAME PROCESS_NAME
START CHAR(108) SESSION_ID SESSION_ID
104 Pre-R2.4 SP2 Query Statistics Views