HP Neoview Release 2.3 Software - Manual (Page 28)

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 account representative for assistance in changing the configuration.
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.
Table 3-4 QUERY_RUNTIME_STATS_V1 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. SMALLINT UNSIGNED NO
DEFAULT SEGMENT_ID
Node number of the Master Executor
(where the main query process runs). SMALLINT UNSIGNED NO
DEFAULT NODE_ID
Process identification number of the
Master Executor. SMALLINT UNSIGNED NO
DEFAULT PIN
Starting priority of the Master Executor
process. SMALLINT UNSIGNED NO
DEFAULT START_PRIORITY
Cumulative node utilization
percentage for the Master Executor
process during the elapsed time of this
query. SMALLINT UNSIGNED NO
DEFAULT MASTER_BUSY*
Cumulative node utilization
percentage for the busiest Executor
Server Process in the query. SMALLINT UNSIGNED NO
DEFAULT NODE_BUSY_FOR_BUSIEST_ESP*
Percentage of available processing
node resources (for the whole Neoview
platform) used by the Master Executor
process and all its child processes for
this query. SMALLINT UNSIGNED NO
DEFAULT PCT_BUSY_ALL_PROCESSES*
Node of the busiest Executor Server
Process involved in the query. SMALLINT UNSIGNED NO
DEFAULT BUSIEST_ESP_NODE*
Process identification number of the
busiest Executor Server Process
involved in the query. SMALLINT UNSIGNED NO
DEFAULT BUSIEST_ESP_PIN*
Segment of the busiest Executor Server
Process involved in the query. SMALLINT UNSIGNED NO
DEFAULT BUSY_ESP_SEGMENT*
Level of utilization that causes a
process to be identified as busy. SMALLINT UNSIGNED NO
DEFAULT BUSY_THRESHOLD*
28 Repository Views