HP Neoview Release 2.5 Software - Manual (Page 116)

Table E-5 QUERY_RUNTIME_STATS_V1_2400 Field Definitions (continued)
Description Data Type
Field Name (* means available only in
this view)
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
QUERY_STATS_VW1 and SQL_TEXT_VW1 so that you can obtain query statistics in a single
row.
CAUTION: Although your pre-R2.4 SP1 queries will not fail due to view changes, some fields
are no longer available in ODBC_QUERY_STATS_V1, ODBC_QUERY_STATS_V2, and
QUERY_RUNTIME_STATS_V1. These fields now return NULL values when you run queries
using these views. For details, see
Table F-1 (page 132) .
VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V1
This view preserves separate rows for data collected at the start and end of a query. 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 STATEMENT_STATUS.
Character columns use ISO88591 or UCS2 encoding, as appropriate to the Neoview platform
configuration. If the platform is UCS2 or SJIS, all character columns are created with CHARACTER
SET UCS2. If the platform is ISO88591, all CHAR columns are created with CHARACTER SET
ISO88591.
The primary key for the ODBC_QUERY_STATS_V1_2400 field definition is SEGMENT_ID,
NODE_ID, SEQUENCE_NUM and the date/time fields (QUERY_EVENT_DATETIME_UTC and
other date fields).
116 Pre-R2.5 Query Statistics Views