HP Neoview Release 2.5 Software - Manual (Page 123)

Table E-8 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.
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
Process identification 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 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*
Cumulative node utilization
percentage for all the Executor Server
Processes. SMALLINT UNSIGNED NO
DEFAULT PCT_NODE_BUSY_ALL_ESPS*
Node utilization percentage for all
query processes for the last statistics
collection interval. SMALLINT UNSIGNED NO
DEFAULT PCT_TOT_BUSY_FOR_INTERVAL*
Node utilization percentage for all
Executor Server processes for the last
interval. SMALLINT UNSIGNED NO
DEFAULT ESP_BUSY_FOR_INTERVAL*
Query Statistics for Release 2.4 123