HP Neoview Release 2.4 Software - Manual (Page 22)

Table 3-1 Comparison of ODBC Query Statistics and Query Runtime Statistics (continued)
Query Runtime Statistics ODBC Query Statistics
Service name is available. Data source name is available.
Data is available only for queries monitored by WMS.
(WMS monitors only NON_UNIQUE queries.) Data is available for all queries, whether unique or
non-unique.
Synchronized with QueryRTS entity in Neoview
Management Dashboard. Not synchronized with query data in Neoview
Management Dashboard.
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. In the following table:
• If a data type is given as CHAR or NCHAR, then CHAR applies if the character set is
ISO88591, and NCHAR applies if the character set is UCS2.
• If a data type is given as VARCHAR or NCHAR VARYING, the VARCHAR applies if the
character set is ISO88591, and NCHAR VARYING applies if the character set is UCS2.
The primary key for the ODBC_QUERY_STATS_V1 field definition is SEGMENT_ID, NODE_ID,
SEQUENCE_NUM and the date/time fields (QUERY_EVENT_DATETIME_UTC and other date
fields).
Table 3-2 ODBC_QUERY_STATS_V1 Field Definitions
Description Data Type Field Name
Segment number of the NDCS server
that reported the statistics. INTEGER UNSIGNED SEGMENT_ID
Processing node number of the NDCS
server which reported the statistics.
This is the node where the master
executor process which executed the
query was running. INTEGER UNSIGNED NODE_ID
ANSI SQL timestamp in Local Civil
Time when the statistics were
recorded in the Repository. TIMESTAMP(6) QUERY_EVENT_DATETIME
ANSI SQL date in Local Civil Time
when the statistics were recorded in
the Repository. DATE QUERY_EVENT_DATE
ANSI SQL time in Local Civil Time
when the statistics were recorded in
the Repository. TIME(6) QUERY_EVENT_TIME
ANSI SQL timestamp in Coordinated
Universal Time when the statistics
were recorded in the Repository. TIMESTAMP(6) QUERY_EVENT_DATETIME_UTC
ANSI SQL date in Coordinated
Universal Time when the statistics
were recorded in the Repository. DATE QUERY_EVENT_DATE_UTC
ANSI SQL time in Coordinated
Universal Time when the statistics
were recorded in the Repository. TIME(6) QUERY_EVENT_TIME_UTC
22 Repository Views