HP Neoview Release 2.4 Software - Manual (Page 100)

Table C-4 QUERY_RUNTIME_STATS_V1_2400 Field Definitions (continued)
Description Data Type
Field Name (* means available only in
this view)
ANSI Timestamp indicating when the
Workload Management Services
received the most recent runtime
statistics from the Query Executor. TIMESTAMP(6) NO DEFAULT REFRESH_TS
Repository-generated ANSI
Timestamp showing when this row
was last updated. You can use this
value to monitor whether the query is
still running. TIMESTAMP(6) NO DEFAULT LAST_UPDATE_TS
ANSI Timestamp, in Local Civil Time,
indicating when query compilation
began. If this information is initially
unavailable, it is assigned the value
NULL and later updated with the
correct value. This field is updated
whenever the Repository updates the
statistics. TIMESTAMP(6) NO DEFAULT COMPILE_START_TS
ANSI Timestamp, in Local Civil Time,
indicating when query compilation
ended. If this information is initially
unavailable, it is assigned the value
NULL and later updated with the
correct value. This field is updated
whenever the Repository updates the
statistics. TIMESTAMP(6) NO DEFAULT COMPILE_END_TS
ANSI Timestamp, in Local Civil Time,
indicating when query execution
began. If the query has not yet begun
execution, the value is NULL. TIMESTAMP(6) NO DEFAULT EXEC_START_TS
ANSI Timestamp indicating when
query execution ended, converted to
LCT from UTC. If the query has not
yet begun execution, the value is
NULL. TIMESTAMP(6) NO DEFAULT EXEC_END_TS
1 Total memory used by a query in the sum: “SQL Space Used” + “SQL Heap Used” + “EID Space Used” + “EID Heap
Used”. This value changes during the lifetime of a query.
Query Statistics for Release 2.4
In Repository R2.4, these three views were used to collect ODBC/JDBC query statistics and
runtime statistics. These views access current Repository data, but they use the pre-R2.4 SP1
"two rows per query" semantics of query statistics. Your existing queries will continue to work;
however, update your applications as soon as possible to use the new query statistics views
100 Pre-R2.4 SP2 Query Statistics Views