HP Neoview Release 2.3 Software - Manual (Page 29)

Table 3-4 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)
Description Data Type
Field Name (* means available only in
this view)
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*
Node utilization for the Master
Executor for the last interval. SMALLINT UNSIGNED NO
DEFAULT MASTER_BUSY_FOR_INTERVAL*
Minimum priority this Master
Executor has had while executing. SMALLINT UNSIGNED NO
DEFAULT MIN_PRIORITY_ESP*
Estimated parallelism of the query,
computed as
BusyExecutorServerProcesses
/Number
of processors * 100.
SMALLINT UNSIGNED NO
DEFAULT EST_PARALLELISM*
Difference in minutes between the time
when WMS last refreshed statistics
from RTS (REFRESH_TS value) and
the time when the Repository last
wrote this row (LAST_UPDATE_TS).
Indicates lag time, if any, between
WMS statistics and Repository
statistics. INTERVAL MINUTE(6) NO
DEFAULT LAG_ELAPSED_TIME*
Offset in minutes between Local Civil
Time and UTC when this record was
written. INTERVAL MINUTE(3) NO
DEFAULT UTC_BIAS
Repository internal. Identification
number of the Query Runtime
Statistics metric class (measurement)
in the Metric Class Registry. INTEGER UNSIGNED NO
DEFAULT METRIC_CLASS_ID
Repository internal. Internal version
number of the Query Runtime
Statistics metric (measurement) in the
Metric Class Registry. INTEGER UNSIGNED NO
DEFAULT METRIC_CLASS_VERSION
Repository internal. CHAR(10) or NCHAR(10) NO
DEFAULT METRIC_CTRL
SQL error code, if any, returned in
response to this query. The value is 100
for completed SELECT, UPDATE, or
DELETE statements with actual end
statistics. The value is 0 for completed
INSERT queries or for uncompleted
queries. A negative number indicates
an execution-type error. INTEGER SIGNED NO DEFAULT ERROR_CODE
Number assigned to the query by
WMS. INTEGER SIGNED NO DEFAULT QUERY_INDEX*
Unique numeric ID for the service,
assigned by WMS. Corresponds to
SERVICE_NAME. INTEGER SIGNED NO DEFAULT SERVICE_INDEX*
Query Statistics 29