Neoview Workload Management Services Guide (R2.5)

ADD RULE CONN Command
The ADD RULE CONN command defines a connection rule.
NOTE: Only administrators are permitted to run this command. By default, an administrator
is a user associated with ROLE.DBA, SUPER.SERVICES, or SUPER.SUPER.
Syntax
ADD RULE CONN rule-specifier
rule-specifier is:
rule-name ( rule-specifier-list [, warn-level] [, rule-action ] [, aggregation] )
[ rule-comment ]
rule-specifier-list is:
conn-expression [, conn-expression ] ...
conn-expression is:
SESSION { string-value | ICASE (string-value) }
| LOGIN { string-value | ICASE (string-value)}
| APPL { string-value | ICASE (string-value)}
| DSN { string-value | ICASE (string-value)}
warn-level is:
{ WARN-LOW
| NO-WARN }
rule-action is:
{ SQL_CMD "sql-string;" }
aggregation is:
AGGREGATE aggregate-parameter-list
aggregate-parameter-list is:
aggregate-parameter
| (aggregate-parameter[, aggregate-parameter]...)
aggregate-parameter is:
QUERY_TYPE query-type-list
| REPOS_INTERVAL time-value
| WMS_INTERVAL time-value
| EXEC_INTERVAL time-value
query-type-list is:
query-type
| (query-type[, query-type]...)
query-type is:
{ INSERT | UPDATE | DELETE | SELECT | ALL }
rule-comment is:
{ COMMENT "comment-string" }
rule-name
is the name of a user-defined rule. rule-name can be a maximum of 24 characters and must
be a unique name in WMS. You cannot add a rule that has the same name as one of the
predefined rules, HPS_MANAGEABILITY1 through 11 and HPS_TRANSPORTER1. The
rule name is not case-sensitive and is always converted to uppercase. The rule name cannot
contain spaces. WMS supports multibyte characters in the rule name. For guidelines on using
multibyte character sets, see the Neoview Character Sets Administrator's Guide.
rule-specifier-list
specifies one or more comma-separated conn-expression. WMS tests each
conn-expression in the rule-specifier-list in the order in which you specify them.
178 WMS Commands