Neoview Workload Management Services Guide (R2.5)

Description or ActionAttribute or FieldGroup Box
Select one of these query statistics to evaluate:
• USED_ROWS, which is the number of rows returned to the query
• ACCESSED_ROWS, which is the number of rows accessed by the query
• TOTAL_MEM_ALLOC, which is the total memory used to process the
query
• ELAPSED_TIME, which is the elapsed time of the query execution (that
is, the time since the start of the query execution until the current time,
including any time that the query spent in the waiting, holding, or
suspended state)
• CPU_TIME, which is the amount of processor (CPU) time used by
Neoview SQL for the query
IMPORTANT: If you select this option, be aware that the query cost
model, which influences the CPU time, might change in the future.
Property
Select one of these comparison operators:
• =
• >=
• >
• <
• <=
• <>
• %
Operator
If you selected % for the operator, enter a percentage from 100 to 1000.
When WMS evaluates the execution rule, it checks if the first operand of the
expression (from the Property list) is greater than the second operand (from
the Value box) by this percentage.
Percentage
Enter a value to be compared with the compiler estimate:
• For USED_ROWS, enter a numeric value, or select EST_USED_ROWS.
EST_USED_ROWS is the compiler estimate.
• For ACCESSED_ROWS, enter a numeric value, or select
EST_ACCESSED_ROWS. EST_ACCESSED_ROWS is the compiler
estimate.
• For TOTAL_MEM_ALLOC, enter a numeric value in kilobytes (KB), or
select EST_TOTAL_MEMORY. EST_TOTAL_MEMORY is the compiler
estimate.
• For ELAPSED_TIME, enter a numeric value in minutes.
• For CPU_TIME, enter a numeric value in seconds, or select
EST_CPU_TIME. EST_CPU_TIME is the compiler estimate.
Value
Disabled for execution rulesIgnore Case
When you click the [+ Add Expr] button, the expression appears in this field.
This field can contain up to 15 expressions.
Expression
Enter optional text to describe the rule. The text cannot exceed 256 characters.CommentsComments
This read-only field displays the WMS command that will be issued when
you add the rule.
Command PreviewCommand
Preview
Execution Rules 107