HP Neoview Release 2.5 Software - Manual (Page 130)

Table E-8 QUERY_RUNTIME_STATS_V1 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.
130 Pre-R2.5 Query Statistics Views