HP Neoview Release 2.4 Software - Manual (Page 106)

Table C-6 ODBC_QUERY_STATS_V2 Fields (continued)
Source and Notes Data Type Incomplete Queries Complete Queries
END, or NULL for
an incomplete
query TIME QUERY_START_TIME_UTC QUERY_END_TIME_UTC
START, else END,
else NULL DOUBLE
PRECISION EST_COST
END, or NULL for
an incomplete
query LARGEINT QUERY_ELAPSED_TIME
END, or NULL for
an incomplete
query LARGEINT MASTER_EXECUTION_TIME
END, or NULL for
an incomplete
query LARGEINT DISK_READS
END, or NULL for
an incomplete
query LARGEINT LOCK_ESCALATIONS
END, or NULL for
an incomplete
query LARGEINT LOCK_WAITS
END, or NULL for
an incomplete
query LARGEINT MESSAGE_BYTES_TO_DISK
END, or NULL for
an incomplete
query LARGEINT MESSAGES_TO_DISK
END, or NULL for
an incomplete
query LARGEINT ROWS_ACCESSED
END, or NULL for
an incomplete
query LARGEINT ROWS_RETRIEVED
END, or NULL for
an incomplete
query LARGEINT NUM_ROWS_IUD
END, or NULL for
an incomplete
query LARGEINT TOTAL_EXECUTES
START VARCHAR(3200) SQL_TEXT
NOTE: In both ODBC_QUERY_STATS_V1 and ODBC_QUERY_STATS_V2, the QUERY_ID
field contains the unique ID of the query unless an error occurs before the query is launched. In
this case, no query ID is assigned, and the corresponding field is populated with the value
. The rest of the information pertaining to the query, including the error code, is stored
in the appropriate columns.
VIEW NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1
This view provides information collected while a query is running. The Repository obtains this
information through a statistics gathering process within the Neoview Management Dashboard.
106 Pre-R2.4 SP2 Query Statistics Views