Neoview Workload Management Services Guide (R2.5)

Table A-14 Query Runtime Statistics (continued)
DescriptionData TypeColumn Name
Displayed as rule-name:expr-num, where rule-name
is the last compilation rule evaluated for the query and
expr-num is either the ordinal position of the expression
that evaluated to true or ALL for all expressions evaluating
to true
VARCHAR(100)COMP_RULE_NAME
Displayed as rule-name:expr-num, where rule-name
is the last execution rule evaluated for the query and
expr-num is either the ordinal position of the expression
that evaluated to true or ALL for all expressions evaluating
to true
VARCHAR(100)EXEC_RULE_NAME
Total Number of Executing Queries in Various States
The STATUS QUERIES EXECUTING STATS returns the total number of executing queries in
various states on each segment of the Neoview platform:
Table A-15 Total Number of Executing Queries in Various States
DescriptionData TypeColumn Name
Segment numberINTSEGMENT
Number of executing queries in the initialization state for this segmentINTTOT_INITIAL
Number of executing queries in the open state for this segmentINTTOT_OPEN
Number of executing queries in the end-of-file state for this segmentINTTOT_EOF
Number of executing queries in the close state for this segmentINTTOT_CLOSE
Number of executing queries in the deallocate state for this segmentINTTOT_DEALLOCATED
Number of executing queries in the fetch state for this segmentINTTOT_FETCH
Number of executing queries in the close_tables state for this segmentINTTOT_CLOSE_TABLES
Number of executing queries in the prepare state for this segmentINTTOT_PREPARE
236 WMS Commands