Neoview Workload Management Services Guide (R2.4)

CONN CONNRULE22 AND 1 APPL = NCI LOW SET SCHEMA SALES; SET
TRANSACTION ISOLATION LEVEL SERIALIZABLE;
CONN CONNRULE22 AND 2 DSN ICASE (DSN1) LOW SET SCHEMA SALES; SET
TRANSACTION ISOLATION LEVEL SERIALIZABLE;
CONN CONNRULE23 AND 1 APPL = NCI NO-WARN
--- WMS operation complete.
NS%
For the syntax, see the “STATUS RULE CONN Command” (page 140). Also see “How to Execute
WMS Commands in NCI” (page 25).
Altering a Connection Rule
IMPORTANT: To remove an action, SQL_CMD "sql-string", from a connection rule, you
must delete and then add the connection rule instead of using the ALTER RULE CONN command.
For more information, see “Deleting a Connection Rule” (page 46) and “Adding a Connection
Rule” (page 42).
Use the ALTER RULE CONN command to change the attributes of a connection rule. This ALTER
RULE CONN command changes the warning level from WARN-LOW to NO-WARN and changes
the SQL commands in the connection rule, CONNRULE22:
NS%alter rule conn connrule22 (APPL NCI, DSN ICASE(DSN1), NO-WARN, SQL_CMD "SET SCHEMA SALES;")
--- WMS operation complete.
CAUTION: When altering an attribute of the connection rule, you must also specify any existing
attributes in the ALTER RULE CONN command. Otherwise, the ALTER RULE CONN command
deletes the existing attributes.
For example, suppose you want to change the client login role of CONNRULE1 from ROLE.USR1
to ROLE.USR3 but want to keep the session name of JOB2468. To change the login role yet retain
the session name, you must run this ALTER RULE CONN command:
ALTER RULE CONN CONNRULE1 (SESSION JOB2468, LOGIN ROLE.USR3);
Running the following ALTER RULE CONN command changes the login role but deletes the
session name from the connection rule:
NS%alter rule conn connrule1 (login ROLE.USR3);
--- WMS operation complete.
NS%status rule connrule1;
TYPE NAME OPER EXPR_PRTY EXPR WARN_LEVEL ACT COMMENT
---- ------------ ---- ----------- ------------------ ---------- ------------- -----------
CONN CONNRULE1 AND 1 LOGIN = ROLE.USR3 NO-WARN
--- WMS operation complete.
NS%
For the syntax, see the “ALTER RULE CONN Command” (page 97). Also see “How to Execute
WMS Commands in NCI” (page 25).
Deleting a Connection Rule
Use the DELETE RULE command to delete a rule. After you delete a rule, all associations with
services using the rule are deleted. This DELETE RULE command removes the connection rule
named CONNRULE22 from the WMS configuration:
NS%delete rule CONNRULE22;
--- WMS operation complete.
NS%
For the syntax, see the “DELETE RULE Command” (page 111). Also see “How to Execute WMS
Commands in NCI” (page 25).
46 Configuring Rules