Neoview Workload Management Services Guide (R2.4)

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 ROLE.DBA or the super ID (super.services or super.super).
Syntax
ADD RULE CONN rule-specifier
rule-specifier is:
rule-name ( rule-specifier-list [, warn-level] [, rule-action ])
[ 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;" }
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 9 and HPS_TRANSPORTER1. The rule
name is not case-sensitive and is always converted to uppercase. 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.
conn-expression
specifies one of these connection rule expressions:
Specifies the session name for the connection rule. The keyword
ICASE causes the NDCS server to ignore the case during the
comparison of the session name from the client and the connection
rule. The maximum character length is 24. Put string-value
within double quotes when it contains spaces. SESSION does not
support multibyte characters.
SESSION { string-value | ICASE
(string-value) }
Specifies the client login role (not alias) for the connection rule. The
keyword ICASE causes the NDCS server to ignore the case during
the comparison of the login role from the client and the connection
rule. The maximum character length is 17. Put string-value
within double quotes when it contains spaces. LOGIN does not
support multibyte characters.
LOGIN { string-value | ICASE
(string-value) }
86 WMS Commands