HP Neoview Release 2.4 Software - Manual (Page 109)

Table C-7 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)
Description Data Type
Field Name (* means available only in
this view)
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
Amount of “space” type (static)
memory, in kilobytes, actually used
for query processes (master executor
and ESPs) during query execution. It
should be less than or equal to the
SQL_SPACE_ALLOCATED value.
Maximum value of
SQL_SPACE_USED reached over the
life of the query. INTEGER SIGNED NO DEFAULT SQL_SPACE_USED*
1
Amount of “heap” type (dynamic)
memory, in kilobytes, allocated
(reserved) for query processes (master
executor and ESPs) at the beginning of
query execution. The processes that
execute the query request this memory
during execution, thus the amount can
change as the query runs. Maximum
value of SQL_HEAP_ALLOCATED
reached over the life of the query. INTEGER SIGNED NO DEFAULT SQL_HEAP_ALLOCATED*
1
VIEW NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1 109