Neoview Repository User Guide (R2.4 SP1)

Table 3-1 QUERY_STATS_VW1 Field Definitions (continued)
DescriptionData TypeField Name
Size, in bytes, of the total number of
messages sent to the Encapsulated SQL
Access Manager (ESAM).
LARGEINT DEFAULT
NULL
MESSAGE_BYTES_TO_DISK
Number of messages sent to ESAM. That is,
the number of messages exchanged between
the file system and the disk process.
LARGEINT DEFAULT
NULL
MESSAGES_TO_DISK
Cumulative number of rows accessed in each
table to evaluate the statement. This includes
records examined by the disk process, the
file system, and the SQL Executor.
LARGEINT DEFAULT
NULL
ROWS_ACCESSED
Cumulative number of rows retrieved and/or
actually used. Number of rows that were
returned by Executor in Disk (EID) process.
LARGEINT DEFAULT
NULL
ROWS_RETRIEVED
Number of rows actually inserted, updated,
deleted in the base tables, by a query.
LARGEINT DEFAULT
NULL
NUM_ROWS_IUD
The number of OPEN partition calls
performed by the SQL Executor on behalf of
this query.
LARGEINT DEFAULT
NULL
NUM_OPENS
Time in microseconds this process spent
doing file OPENs.
LARGEINT DEFAULT
NULL
OPEN_BUSY_TIME
Time in seconds this process spent doing file
OPENs.
FLOAT(54) DEFAULT
NULL
OPEN_BUSY_TIME_SEC
Number of new processes created by the
Executor on behalf of this process.
INTEGER UNSIGNED
DEFAULT NULL
PROCESSES_CREATED
Time in microseconds the Executor spent
creating new processes.
LARGEINT NO
DEFAULT
PROCESS_CREATE_BUSY_TIME
Time in seconds the Executor spent creating
new processes.
FLOAT(54) DEFAULT
NULL
PROCESS_CREATE_BUSY_TIME_SEC
The first 254 characters of query SQL text. If
query text is longer than 254 characters, the
entire query text is available in “VIEW
NEO.HP_METRICS.SQL_TEXT_VW1”
(page 34).
CHAR(254) DEFAULT
NULL
SQL_TEXT
Indicates the status of the SQL_TEXT field:
• zero (0)– all SQL Text for the query is
in this field.
• 1 – only a preview (the first 254
characters) of the text is in the SQL_TEXT
field and the entire query text is stored in
“VIEW
NEO.HP_METRICS.SQL_TEXT_VW1”
(page 34)
SMALLINT UNSIGNED
DEFAULT NULL
SQL_TEXT_OVERFLOW_INDICATOR
VIEW NEO.HP_METRICS.SQL_TEXT_VW1
This view allows access to the complete SQL text for a query.
When the SQL text for a query is 254 characters or fewer, the text is written to the
QUERY_STATS_VW1 view and the SQL_TEXT_OVERFLOW_INDICATOR field is set to 0. If the
text is longer, the first 254 characters are written to QUERY_STATS_VW1 and
SQL_TEXT_OVERFLOW_INDICATOR is set to 1, indicating that the complete SQL text is found
in the SQL_TEXT field of SQL_TEXT_VW1. In SQL_TEXT_VW1, each row of SQL text can contain
34 Repository Views