Neoview Workload Management Services Guide (R2.5)

Examples
• This command alters the connection rule, CONNRULE1, so that it requires the client session
to have a user logged in as ROLE.USR3 instead of ROLE.USR1:
ALTER RULE CONN CONNRULE1 (SESSION ICASE(JOB2468), LOGIN ICASE(ROLE.USR3));
• This command alters the connection rule, CONNRULE22, so that it issues only one SQL
command and does not issue a warning when the rule evaluates to true:
ALTER RULE CONN CONNRULE22 (APPL ICASE(NCI), DSN ICASE(DS1), NO-WARN,
SQL_CMD "SET SCHEMA SALES;");
• This command alters the connection rule, CONNRULE5, to turn off query statistics
aggregation:
ALTER RULE CONN CONNRULE5 (AGGREGATE NO-ACTION);
• This command alters the connection rule, CONNRULE7, so that the query statistics for
UPDATE statements are no longer aggregated and changes the aggregation parameters:
ALTER RULE CONN CONNRULE7 (AGGREGATE (QUERY_TYPE (INSERT, DELETE),
REPOS_INTERVAL 2, WMS_INTERVAL 2, EXEC_INTERVAL 2));
The REPOS_INTERVAL parameter causes the NDCS server to update the Neoview
Repository every two minutes with the aggregated statistics. The WMS_INTERVAL parameter
causes the NDCS server to update WMS every two minutes with the latest aggregated
statistics for display. The EXEC_INTERVAL specifies that the maximum execution time of
the query is expected to be two minutes or less. If the execution time of the query is longer
than two minutes, the NDCS server does not aggregate the query statistics but instead saves
the individual statistics from each execution of the query in the Repository.
ALTER RULE CONN Command 195