Neoview Workload Management Services Guide (R2.5)

Table A-14 Query Runtime Statistics (continued)
DescriptionData TypeColumn Name
Warning number returned to the statistics collector while
it is obtaining statistics from runtime statistics. A warning
of 8922 means that one or more CPUs did not report the
statistics for a given query.
INTSTATS_ERROR_CODE
Amount, in kilobytes, of the space type of memory
allocated in the master and executor server processes (ESPs)
involved in processing the query
LARGEINTSQL_SPACE_ALLOC
Amount, in kilobytes, of the space type of memory used
in the master and ESPs involved in processing the query
LARGEINTSQL_SPACE_USED
Amount, in kilobytes, of the heap type of memory allocated
in the master and ESPs involved in processing the query
LARGEINTSQL_HEAP_ALLOC
Amount, in kilobytes, of the heap type of memory used in
the master and ESPs involved in processing the query
LARGEINTSQL_HEAP_USED
Approximation, in microseconds, of the total CPU time
spent in the master and ESPs involved in processing the
query
LARGEINTSQL_CPU_TIME
Amount, in kilobytes, of the space type of memory
allocated in the EID (executor code in DP2 processes)
involved in processing the query
LARGEINTEID_SPACE_ALLOC
Amount, in kilobytes, of the space type of memory used
in the EID involved in processing the query
LARGEINTEID_SPACE_USED
Amount, in kilobytes, of the heap type of memory allocated
in the EID involved in processing the query
LARGEINTEID_HEAP_ALLOC
Amount, in kilobytes, of the heap type of memory used in
the EID involved in processing the query
LARGEINTEID_HEAP_USED
The sum of SQL_SPACE_USED and SQL_HEAP_USED.INTTOTAL_MEM_ALLOC
Estimated number of rows accessed by the queryDOUBLE
PRECISION
EST_ACCESSED_ROWS
Estimated number of rows used by the queryDOUBLE
PRECISION
EST_USED_ROWS
Number of processes generated by the executor on behalf
of this query
LARGEINTPROCESSES_CREATED
Time spent creating processesLARGEINTPROCESS_CREATE_TIME
Local civil time when the shared memory block was last
updated.
LARGEINTLAST_UPDATED
Either YES or NO, indicating whether the query's statistics
are aggregated. For more information, see “Query Statistics
Aggregation” (page 27).
VARCHAR(3)AGGR_QUERY
Total number of queries in the aggregated queryLARGEINTAGGR_TOTAL_QUERIES
Difference in seconds between the current time and the
last time that the aggregation was updated
LARGEINTAGGR_SECS_SINCE_LAST_UPDATE
Difference in seconds between the current time and the
first time that aggregation was updated
LARGEINTAGGR_SECS_TOTAL_TIME
Displayed as rule-name:expr-num, where rule-name
is the last connection rule evaluated for the query and
expr-num is the total number of rule expressions
VARCHAR(100)CONN_RULE_NAME
STATUS QUERIES Command 235