Neoview Workload Management Services Guide (R2.4)

Table A-13 Query Runtime Statistics (continued)
DescriptionData TypeColumn Name
Number of OPEN calls performed by the executor on behalf of
this process
LARGEINTOPENS
Time the process spent doing OPENsLARGEINTOPEN_TIME
Top-level error code returned by the query, indicating whether
the query completed successfully or with warnings or errors
INTSQL_ERROR_CODE
Number of rows inserted, updated, or deleted by the queryLARGEINTNUM_ROWS_IUD
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
INTSQL_SPACE_ALLOC
Amount, in kilobytes, of the space type of memory used in the
master and ESPs involved in processing the query
INTSQL_SPACE_USED
Amount, in kilobytes, of the heap type of memory allocated in
the master and ESPs involved in processing the query
INTSQL_HEAP_ALLOC
Amount, in kilobytes, of the heap type of memory used in the
master and ESPs involved in processing the query
INTSQL_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
INTEID_SPACE_ALLOC
Amount, in kilobytes, of the space type of memory used in the
EID involved in processing the query
INTEID_SPACE_USED
Amount, in kilobytes, of the heap type of memory allocated in
the EID involved in processing the query
INTEID_HEAP_ALLOC
Amount, in kilobytes, of the heap type of memory used in the
EID involved in processing the query
INTEID_HEAP_USED
The sum of SQL_SPACE_USED and SQL_HEAP_USED.INTTOTAL_MEM_ALLOC
Estimated number of rows accessed by the queryFLOATEST_ACCESSED_ROWS
Estimated number of rows used by the queryFLOATEST_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
• The STATUS QUERIES EXECUTING STATS returns the total number of executing queries
in various states on each segment of the Neoview platform:
Table A-14 Aggregated Statistics of Executing Queries
DescriptionData TypeColumn Name
Segment numberINTSEGMENT
Number of executing queries in the initialization state for this segmentINTTOT_INITIAL
134 WMS Commands