
When adding a rule, you can provide information in the following fields:
DescriptionField Name
Name of the rule. Up to 24 characters (can be multi-bytes). Rule names
support Neoview character sets.
Rule Name
WARN-HIGH, WARN-MEDIUM, WARN-LOW (Default), NO-WARNWarn Level
REJECT, HOLD, SQL_CMD (SQL string) (SQL string can be multi-bytes),
NO-ACTION
Rule Action
AND, ORExpression: Logical
EST_TOTAL_MEMORY, EST_TOTAL_TIME, EST_CARDINALITY,
EST_ACCESSED_ROWS, EST_USED_ROWS, NUM_JOINS, SCAN_SIZE,
UPDATE_STATS_WARNING (Boolean — Operator/Value are empty)
Expression: Property
Empty (for UPDATE_STATS_WARNING), =. >=, >, <, <=, <>Expression: Operator
Empty (disabled)Expression: Percentage
Numeric Values (for UPDATE_STATS_WARNING)Expression: Value
1 or more expressions from the property listExpression
Example:
ADD RULE COMP RCOMP3 (AND, EST_TOTAL_MEMORY > 100,
UPDATE_STATS_WARNING , WARN-MEDIUM, HOLD ) COMMENT
"5/11/2010 8:01 AM: New rule added by super-user";
Managing Rules 71
Comentarios a estos manuales