HP Neoview Release 2.4 Software User Manual
Page 31
Table 3-4 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)
Description
Data Type
Field Name (* means available only in
this view)
Difference in minutes between the time
when WMS last refreshed statistics
from RMS. (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. Value will be zero (0).
INTEGER SIGNED NO DEFAULT
QUERY_INDEX*
Unique numeric ID for the service,
assigned by WMS. Corresponds to
SERVICE_NAME. Value will be (0).
INTEGER SIGNED NO DEFAULT
SERVICE_INDEX*
Numeric form of the user ID, an
integer identifying the user.
INTEGER SIGNED NO DEFAULT
USER_ID
Total number of child Executor Server
Processes busy (as busy as or busier
than BUSY_THRESHOLD) during the
last interval.
INTEGER SIGNED NO DEFAULT
NUM_ESPS_GT_THRESHOLD*
Total number of child Executor Server
Processes for the query.
INTEGER SIGNED NO DEFAULT
NUM_CHILD_ESPS*
Total number of child Executor Server
Processes in a suspended state.
INTEGER SIGNED NO DEFAULT
NUM_SUSPENDED_ESPS*
Amount of “space” type (static)
memory, in kilobytes, allocated
(reserved) for query processes (master
executor and ESPs) at the beginning of
query execution. Maximum value of
SQL_SPACE_ALLOCATED reached
over the life of the query.
INTEGER SIGNED NO DEFAULT
SQL_SPACE_ALLOCATED*
1
Query Statistics
31