HP Neoview Release 2.3 Software - Manual (Page 23)

Table 3-2 ODBC_QUERY_STATS_V1 Field Definitions (continued)
Description Data Type Field Name
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
Total NDCS server CPU process time,
in microseconds, from the time the
execute or execdirect started to the
time the results were sent back. Does
not include CPU time consumed by
ESP or disk processes for the query. 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. 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
Prepare error code. A value of 0
indicates that the prepare was
successful. CHARACTER(6) or NCHAR(6) ERROR_CODE
Query Statistics 23