HP Neoview Release 2.4 Software - Manual (Page 37)

Table 3-4 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.
ODBC Session Data
The two views used for retrieval of ODBC session statistics differ in that one
(NEO.HP_METRICS.ODBC_SESSION_STATS_V1) preserves separate rows for data collected
at the start and end of an ODBC Statement Execute, whereas the other
(NEO.HP_METRICS.ODBC_SESSION_STATS_V2) combines all statistics pertaining to the session
in a single row.
VIEW NEO.HP_METRICS.ODBC_SESSION_STATS_V1
This view preserves separate rows for data collected at the start and end of a session.
If information is not available for a field (because the record represents the start of a session and
the field is not populated until the end), the value in that field is NULL. To distinguish easily
between start and end records, you can filter results according to the value of SESSION_STATUS.
Character columns use ISO88591 or UCS2 encoding, as appropriate to the Neoview platform
configuration. In the following table:
ODBC Session Data 37