HP Neoview Release 2.4 Software - Manual (Page 92)

NOTE: In both ODBC_QUERY_STATS_V1_2400 and ODBC_QUERY_STATS_V2_2400, the
QUERY_ID field contains the unique ID of the query unless an error occurs before the query is
launched. In this case, no query ID is assigned, and the corresponding field is populated with
the value <EMPTY>. The rest of the information pertaining to the query, including the error code,
is stored in the appropriate columns.
VIEW NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1_2400
This view provides information collected while a query is running. The Repository obtains this
information through a statistics gathering process within the Neoview Management Dashboard.
Because statistics are updated as the query executes, you can use this view to monitor running
queries. The Repository data for the SERVICE_INDEX and QUERY_INDEX columns in the
QUERY_RUNTIME_STATS_V1 table are not available from the data provider. As a result, the
column values will be zero.
With regard to when query statistics will be present, a single row is written per query execution.
Thus, if the same query is executed 3 times, 3 rows will be present. If a query runs for a long time
(that is, longer than the configured data collection interval), the statistics for that query will be
updated at each data collection interval.
When compared with the other available views that provide information for queries, this one
contains many additional fields. Fields available only in this view are marked with asterisks (*)
in the list below.
Note that only queries managed by Neoview Workload Management Services are reflected in
this view. For information about the features and limitations of WMS, see the Neoview Workload
Management Services Guide.
Also note that query completion statistics are not guaranteed to be present in this view.
The interval for collecting data while a query runs is set in the Dashboard configuration. Contact
your HP Support representative for assistance in changing the configuration.
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 QUERY_RUNTIME_STATS_V1 field definitions is SEGMENT_ID, NODE_ID,
PIN, and SUBMIT_TS.
Table C-4 QUERY_RUNTIME_STATS_V1_2400 Field Definitions
Description Data Type
Field Name (* means available only in
this view)
ANSI Timestamp indicating when the
query first entered Workload
Management Services. TIMESTAMP(6) NO DEFAULT SUBMIT_TS
Segment number of the NDCS
(connectivity) server that reported the
statistics. This is the segment where
the master executor process which
executed the query was running. SMALLINT UNSIGNED NO
DEFAULT 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. SMALLINT UNSIGNED NO
DEFAULT NODE_ID
92 Pre-R2.4 SP2 Query Statistics Views