Neoview Workload Management Services Guide (R2.5)

Table A-14 Query Runtime Statistics (continued)
DescriptionData TypeColumn Name
Internal execution state of the query:
INITIAL
OPEN
EOF
CLOSE
DEALLOCATED
FETCH
CLOSE_TABLES
PREPARE
PROCESS_ENDED
UNKNOWN
For more information, please contact your HP Support
representative.
VARCHAR(21)EXEC_STATE
Elapsed time of query execution, in microseconds.LARGEINTELAPSED_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 the
query
LARGEINTMESSAGE_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
The error code that triggered the Automatic Query Retry
(AQR) for the recent retry
INTLAST_ERROR_BEFORE_AQR
Number of retries that occurred for the query until nowLARGEINTAQR_NUM_RETRIES
The delay in seconds that the SQL engine waited before it
initiated AQR
LARGEINTDELAY_BEFORE_AQR
Number of rows inserted, updated, or deleted by the queryLARGEINTNUM_ROWS_IUD
234 WMS Commands