Neoview Workload Management Services Guide (R2.5)

Table A-13 Query Warning Information (continued)
DescriptionData TypeColumn Name
LOW, MEDIUM, HIGHVARCHAR(6)WARN_LEVEL
Name of the rule that triggered the warningVARCHAR(96)RULE_NAME
Expression number in the rule, corresponding to the ordinal
position of a rule expression that evaluated to true (if the rule was
defined with an OR operator) or the total number of rule
expressions (if the rule was defined with an AND operator)
INTEXPR
Rule expression that triggered the warning. If the rule operator is
AND and there is more than one rule expression, the reason for
the warning is ALL EXPRESSIONS = TRUE.
VARCHAR(512)REASON
Query Runtime Statistics
The STATUS QUERIES command with ALL STATS returns this status information:
NOTE: By default, WMS collects runtime statistics for all the executing queries at an interval
of five seconds. To change this default interval, use the “ALTER WMS Command” (page 204).
If the Repository processes are configured on the Neoview platform, you can also find each query
with all its runtime statistics logged in a Repository view after the query completes execution.
For more information, see the Neoview Repository User Guide.
Table A-14 Query Runtime Statistics
DescriptionData TypeColumn Name
Query identifierVARCHAR(160)QUERY_ID
State of the query:
• WAITING
• EXECUTING
• HOLDING
• SUSPENDED
• REJECTED
• COMPLETED
For more information, see Appendix C (page 263).
VARCHAR(9)QUERY_STATE
Substate of the query. For more information, see
Appendix C (page 263).
VARCHAR(30)QUERY_SUBSTATE
Statement identifier specified by the client applicationVARCHAR(160)STATEMENT_ID
Type of SQL statement specified by the SQL compiler. For
more information, see Appendix B (page 261).
VARCHAR(21)STATEMENT_TYPE
Compilation start timeLARGEINTCOMP_START_TIME
Compilation end timeLARGEINTCOMP_END_TIME
Execution start timeLARGEINTEXEC_START_TIME
Execution end timeLARGEINTEXEC_END_TIME
STATUS QUERIES Command 233