HP Neoview Release 2.5 Software User Manual
Page 71

When adding a rule, you can provide information in the following fields:
Description
Field 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-WARN
Warn Level
REJECT, HOLD, SQL_CMD (SQL string) (SQL string can be multi-bytes),
NO-ACTION
Rule Action
AND, OR
Expression: 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 list
Expression
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