HP Neoview Release 2.5 Software - Manual (Page 117)

Table E-6 ODBC_QUERY_STATS_V1 Field Definitions
Description Data Type Field Name
Segment number of the NDCS server
that reported the statistics. INTEGER UNSIGNED SEGMENT_ID
Processing node number of the NDCS
server which reported the statistics.
This is the node where the master
executor process which executed the
query was running. INTEGER UNSIGNED NODE_ID
ANSI SQL timestamp in Local Civil
Time when the statistics were
recorded in the Repository. TIMESTAMP(6) QUERY_EVENT_DATETIME
ANSI SQL date in Local Civil Time
when the statistics were recorded in
the Repository. DATE QUERY_EVENT_DATE
ANSI SQL time in Local Civil Time
when the statistics were recorded in
the Repository. TIME(6) QUERY_EVENT_TIME
ANSI SQL timestamp in Coordinated
Universal Time when the statistics
were recorded in the Repository. TIMESTAMP(6) QUERY_EVENT_DATETIME_UTC
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) 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
Query Statistics for Release 2.4 117