Neoview Workload Management Services Guide (R2.5)

Description or ActionAttribute or FieldGroup Box
Disabled for compilation rulesTypeAggregate
Disabled for compilation rulesWMS Interval
Disabled for compilation rulesRepository Interval
Disabled for compilation rulesExecute Interval
Select one of these operators:
• AND, which requires that all expressions in the rule evaluate to true for
the rule to be considered true and trigger a warning level or action
• OR, which requires that only one of the expressions in the rule evaluate
to true for the rule to be considered true and trigger a warning level or
action
If you do not select an operator, the default is AND.
LogicalExpression
Select one of these compiler estimates to evaluate:
• EST_TOTAL_MEMORY, which is the estimated memory for the query
• EST_TOTAL_TIME, which is the estimated time to execute the query
• EST_CARDINALITY, which is the estimated total number of rows that
the query will return
• EST_ACCESSED_ROWS, which is the estimated total number of rows
that will be accessed by all the scan, insert, update, and delete operators
• EST_USED_ROWS, which is the estimated total number of rows that
will be accessed by scan and insert operators
• NUM_JOINS, which is the number of joins in the query plan
• SCAN_SIZE, which is the estimated number of rows that will be accessed
by a full scan of a table
• UPDATE_STATS_WARNING, which occurs when there are missing
statistics for a single-column group
• CROSS_PRODUCT, which occurs when there is a join without a predicate
Property
Select one of these comparison operators:
• =
• >=
• >
• <
• <=
• <>
If you selected UPDATE_STATS_WARNING or CROSS_PRODUCT for the
property, this field is disabled.
Operator
Empty (disabled for compilation rules)Percentage
Enter a value to be compared with the compiler estimate:
• For EST_TOTAL_MEMORY, enter a numeric value in kilobytes (KB).
• For EST_TOTAL_TIME, enter a numeric value in minutes.
• For EST_CARDINALITY, enter a numeric value.
• For EST_ACCESSED_ROWS, enter a numeric value.
• For EST_USED_ROWS, enter a numeric value.
• For NUM_JOINS, enter a numeric value.
• For SCAN_SIZE, enter a numeric value.
If you selected UPDATE_STATS_WARNING or CROSS_PRODUCT for the
property, this field is disabled.
Value
Disabled for compilation rulesIgnore Case
When you click the [+ Add Expr] button, the expression appears in this field.
This field can contain up to 15 expressions.
Expression
Compilation Rules 93