Neoview Workload Management Services Guide (R2.5)

Rule Warnings
This table describes information about rule warnings that occurred while the query was running:
DescriptionField
Name of the WMS serviceSERVICE NAME
CONN for a connection rule
COMP for a compilation rule
EXEC for an execution rule
WARN TYPE
LOW, MEDIUM, or HIGHWARN LEVEL
Name of the rule that triggered the warningRULE 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)
EXPR
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.
REASON
Query Text
The Query Text box displays the SQL text associated with the monitored query. If you enabled
SQL text for the service in which the query is running, the Query Text box displays the entire
SQL text for the query. However, if you disabled SQL text for the service in which the query is
running, the Query Text box displays only the first 255 characters of the SQL text. To see the full
SQL text, you must retrieve it from the Neoview Repository. For more information, see “Get the
Query Text” (page 133).
Get the Query Text
To retrieve the SQL text from the Neoview Repository, click the [Get Query Text] button. The
Load Workbench button appears in the Query Text box after the SQL text is retrieved from the
Repository.
Monitor Queries 133