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 CONN Command” (page 178).
After adding a rule, you can view the Rule Details by clicking the name of the rule in the tree
view.
Set the Connection Rule Attributes
This table describes the attributes that you can set for a connection rule when adding or altering
the rule:
Description or ActionAttribute or FieldGroup Box
If you are adding a connection 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 connection rule, select the Connection (CONN) option
if it is not already selected.
If you are altering a connection rule, this is a read-only field.
Rule Type
Select a warning level:
• WARN-LOW
• NO-WARN
If you do not select a warning level, the default is NO-WARN, meaning that
WMS does not set the warning level or save warning information when the
connection rule evaluates to true.
If you want to set the warning level to low and save warning information
when the connection rule evaluates to true, set the warning level of the
connection rule to WARN-LOW.
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:
• SQL_CMD
• NO-ACTION (or empty)
ActionRule Action
If you selected SQL_CMD, enter one or more SQL commands that you want
to execute when connecting to the WMS service. 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
78 Configuring Rules