HP Neoview Release 2.3 Software - Manual (Page 27)

Table 3-3 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 QUERY_END_TIME
END, or NULL for
an incomplete query TIMESTAMP QUERY_START_DATETIME_UTC QUERY_END_DATETIME_UTC
END, or NULL for
an incomplete query DATE QUERY_START_DATE_UTC QUERY_END_DATE_UTC
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_EXEC_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)
or NCHAR
VARYING(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.
Because statistics are updated as the query executes, you can use this view to monitor running
queries.
Query Statistics 27