HP Neoview Release 2.5 Software - Manual (Page 103)

Table E-3 ODBC_QUERY_STATS_V1_2400 Field Definitions (continued)
Description Data Type Field Name
ANSI SQL date in Coordinated
Universal Time when the statistics
were recorded in the Repository. DATE QUERY_EVENT_DATE_UTC
ANSI SQL time in Coordinated
Universal Time when the statistics
were recorded in the Repository. TIME(6) QUERY_EVENT_TIME_UTC
Unique session ID generated by the
NDCS server when the ODBC/JDBC
connection was established. CHARACTER(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_EXECUTION_TIME
Total number of executes performed
on this statement. LARGEINT TOTAL_EXECUTES
Process identification number of the
NDCS server. INTEGER UNSIGNED PIN
Query Statistics for Pre-R2.4 SP1 103