Neoview Workload Management Services Guide (R2.5)

NOTE: You can also perform this task using a WMS command. For more information, see the
“ADD RULE COMP Command” (page 174).
After adding a rule, you can view the Rule Details by clicking the name of the rule in the tree
view.
Set the Compilation Rule Attributes
This table describes the attributes that you can set for a compilation rule when adding or altering
the rule:
Description or ActionAttribute or FieldGroup Box
If you are adding a compilation rule, enter a name for the rule. The name
can be up to 24 characters long and can include multibyte characters. The
name must be unique in WMS. It is not case-sensitive and is always converted
to uppercase.
If you are altering a rule, this is a read-only field.
Rule Name
If you are adding a compilation rule, select the Compilation (COMP) option
if it is not already selected.
If you are altering a compilation rule, this is a read-only field.
Rule Type
Select a warning level:
• WARN-HIGH
• WARN-MEDIUM
• WARN-LOW
• NO-WARN
If you do not select a warning level, the default is WARN-LOW.
If you specify NO-WARN, WMS does not set a warning level or save warning
information for the query when the compilation rule evaluates to true. If
you specify NO-WARN, you must specify a rule action.
If you specify a warning level other than NO-WARN, WMS sets the warning
level (high, medium, or low) for the query and saves warning information
in its shared memory when the compilation rule evaluates to true.
NOTE: The Neoview Performance Analyzer (or the Neoview Query Viewer)
displays the highest warning level for a query in the WARNING LEVEL
field of the Live View pane. To see all the rule warnings that occurred while
the query was running, see the Rule Warnings group box in the Monitoring
Query window of NPA (or NQV), or issue a STATUS QUERIES WARN
command. For more information, see “Display the Query Details” (page 127)
and the “Rule Warnings” (page 133), or see the “STATUS QUERIES
Command” (page 229) and the “Query Warning Information” (page 232).
Warn Level
Select one of these actions that will be triggered when the rule evaluates to
true:
• REJECT, which causes the query to be rejected
• HOLD, which puts the query in the holding state
• SQL_CMD, which causes the NDCS server to execute one or more SQL
commands before executing the query
• NO-ACTION (or empty)
If you selected NO-WARN for the warning level, you must specify an action.
ActionRule Action
If you selected SQL_CMD, enter one or more SQL commands that you want
the NDCS server to execute before executing the query when the rule
evaluates to true. Separate each command with a semicolon (;), and end the
last command with a semicolon. The entire series of commands must not
exceed 1024 bytes. The commands can contain multibyte characters.
SQL String
92 Configuring Rules