Neoview Workload Management Services Guide (R2.3)

Table A-10 Query Runtime Statistics (continued)
DescriptionData TypeColumn Name
— INITIAL
— OPEN
— EOF
— CLOSE
— DEALLOCATED
— FETCH
— CLOSE_TABLES
— PREPARE
— PROCESS_ENDED
— UNKNOWN
VARCHAR(21)EXEC_STATE
Elapsed time of query executionLARGEINTELAPSED_TIME
Number of rows accessed from the tables referenced by the
query. This number includes the records examined by the disk
process, the file system, and the executor.
LARGEINTACCESSED_ROWS
Number of rows actually used by the query.LARGEINTUSED_ROWS
Number of messages sent to execute operations on the tables
referenced by the query, including messages sent by the file
system to the disk process and messages sent by the executor
to the compiler for recompilation. For example, a FETCH
operation through a secondary index generally sends two
messages.
LARGEINTMESSAGE_COUNT
Number of bytes to send and receive messages for this queryLARGEINTMESSAGE_BYTES
Number of bytes to send statistics messages for this queryLARGEINTSTATS_BYTES
Number of disk reads caused by accessing the tables referenced
by the query
LARGEINTDISK_IOS
Number of times the query waited for a lock requestLARGEINTLOCK_WAITS
Number of times a row lock was escalated to a file lock for the
query
LARGEINTLOCK_ESCALATIONS
The actual CPU time in microseconds spent by all DP2s involved
in executing the query
LARGEINTPROCESS_BUSYTIME
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 RTS. 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
72 WMS Commands