Neoview Workload Management Services Guide (R2.5)

Understand the Rule Definitions
This table describes the attributes of the WMS rules that appear in the Rules Summary pane:
DescriptionField
Name of the ruleNAME
Type of the rule:
• CONN for a connection rule
• COMP for a compilation rule
• EXEC for an execution rule
TYPE
Warning level:
• WARN-LOW
• WARN-MEDIUM
• WARN-HIGH
• NO-WARN
WARN_LEVEL
Action taken when the rule evaluates to true:
• HOLD
• REJECT
• CANCEL
• SQL string to execute
ACT
For connection rules, this field contains the types of SQL queries that will have their
statistics aggregated:
• INSERT (unique or non-unique)
• UPDATE (unique or non-unique)
• DELETE (unique or non-unique)
• SELECT (unique—accessing one row of data)
This field does not apply to compilation or execution rules and is therefore blank for
those rules.
For more information, see “Query Statistics Aggregation” (page 27).
AGGR_QUERY_TYPES
For connection rules, this field contains the frequency, in minutes, at which the
aggregated statistics are written to the Repository.
This field does not apply to compilation or execution rules and is therefore set to
zero for those rules.
AGGR_REPOS_INTERVAL
For connection rules, this field contains the frequency, in minutes, at which the NDCS
process updates the WMS process after aggregation has started.
This field does not apply to compilation or execution rules and is therefore set to
zero for those rules.
AGGR_WMS_INTERVAL
For connection rules, this field is the expected execution time of the query, in minutes.
If the query's execution time exceeds this interval, its statistics are written to the
Repository without being aggregated. If the query's execution time is less than or
equal to this interval, its statistics are aggregated.
This field does not apply to compilation or execution rules and is therefore set to
zero for those rules.
AGGR_EXEC_INTERVAL
Comment that describes the ruleCOMMENT
Understand the Rule Definitions 113