HP Neoview Release 2.4 Software - Manual (Page 23)

Table 3-2 ODBC_QUERY_STATS_V1 Field Definitions (continued)
Description Data Type Field Name
Unique session ID generated by the
NDCS server when the ODBC/JDBC
connection was established. CHARACTER(108) or
NCHAR(108) SESSION_ID
Message sequence number generated
by NDCS. Numbering starts at 0 and
is incremented by 1 for each new
record. SMALLINT UNSIGNED SEQUENCE_NUM
Repository assigned value. Used
internally. INTEGER UNSIGNED METRIC_CLASS_ID
Repository assigned value. Used
internally. INTEGER UNSIGNED METRIC_CLASS_VERSION
Number of rows required to
accommodate the query text, which
is provided in 3200–byte chunks. SMALLINT UNSIGNED SEQUENCE_SIZE
Estimated query cost. DOUBLE PRECISION EST_COST
Cumulative number of disk reads. LARGEINT DISK_READS
Cumulative number of times record
locks were escalated to file locks. LARGEINT LOCK_ESCALATIONS
Number of times the statement
waited for a lock request
(concurrency cost). LARGEINT LOCK_WAITS
Size, in bytes, of the total number of
messages sent to the Encapsulated
SQL Access Manager (ESAM). LARGEINT MESSAGE_BYTES_TO_DISK
Number of messages sent to ESAM. LARGEINT MESSAGES_TO_DISK
Cumulative number of rows accessed. LARGEINT ROWS_ACCESSED
Cumulative number of rows
retrieved. LARGEINT ROWS_RETRIEVED
Number of rows inserted, updated,
deleted. LARGEINT NUM_ROWS_IUD
Total NDCS server real time, in
microseconds, from the time the
execute or execdirect started to the
time the results were sent back. LARGEINT QUERY_ELAPSED_TIME
Node processing time. LARGEINT MASTER_EXEC_EXECUTION_TIME
Total number of executes performed
on this statement. LARGEINT TOTAL_EXECUTES
Process identification number of the
NDCS server. INTEGER UNSIGNED PIN
START if this record contains
information collected at the start of
the query, or END if it contains
statistics collected at the end of the
query.
CANCELLED for queries killed
through Neoview Query Viewer. CHARACTER(5) or NCHAR(5) STATEMENT_STATUS
Execution priority of the NDCS
process at the time the connection
request is received. SMALLINT UNSIGNED START_PRIORITY
Query Statistics 23