Add a new execution rule – HP Neoview Release 2.4 Software User Manual

Page 59

Advertising
background image

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 );

Add a New Execution Rule

To add an execution rule, on the Add Rule dialog, set the Rule Type radio button to Execution.

•

Warn Level

and Rule Action attributes are optional. You can specify as needed. NO-ACTION

resets the CANCEL action on a execution rule.

•

In the expression group box, select a predefined property from the drop down box and then
enter a value in the Value field. You can optionally select the Ignore case checkbox to ignore

Neoview WMS Services Configuration

59

Advertising