HP Neoview Release 2.5 Software - Manual (Page 27)

Table 3-1 QUERY_STATS_VW2 Field Definitions (continued)
Description Data Type Field Name
What the executor is doing. Possible query
states include:
INITIAL
OPEN
EOF
CLOSE
DEALLOCATED
FETCH
CLOSE_TABLES
PROCESS_ENDED
UNKNOWN
NULL
CHAR(25) DEFAULT
NULL QUERY_EXECUTION_STATE
Warning level from WMS. Possible levels
include:
LOW
MEDIUM
HIGH
NONE
CHAR(7) DEFAULT
NULL WARN_LEVEL
SQL error code, if any, returned while
obtaining statistics for the query. Indicates
whether the query completed with warnings,
errors or successfully:
• Positive number – Warning
For example, warning 8922 – one or more
nodes did not report statistics for this
query.
• Negative number – Error
• Zero (0) or 100 – Success
INTEGER DEFAULT
NULL STATS_ERROR_CODE
Query wait time in seconds. The amount of
time a query waited in WMS for a resource
(for example, CPU time) to become available
for the query to start executing. LARGEINT DEFAULT
NULL WAIT_TIME
Query hold time in seconds. The amount of
time the query spent in a WMS queue in a
HOLDING or SUSPENDED state due to:
• Rules configured in WMS.
• An external attempt to hold the query,
such as a HOLD QUERY command
issued from NCI by a WMS
administrator.
This counter is updated during the time
before the query starts executing.
LARGEINT DEFAULT
NULL HOLD_TIME
Elapsed clock time in microseconds from the
time the query started executing to the time
the results were sent back.
Example: 31169481 LARGEINT DEFAULT
NULL QUERY_ELAPSED_TIME
Elapsed clock time, in seconds, from the time
the query started executing to the time the
results were sent back.
Example: 311694 FLOAT(54) DEFAULT
NULL QUERY_ELAPSED_TIME_SEC
Query Statistics 27