Neoview Workload Management Services Guide (R2.5)

ADD RULE CONN CONNRULE1 (SESSION ICASE(JOB2468), LOGIN ICASE(ROLE.USR1));
• This command adds a connection rule that requires the client session to have a session name
called JOB2486 and have the user logged in as ROLE.USR2:
ADD RULE CONN CONNRULE2 (SESSION ICASE(JOB2468), LOGIN ICASE(ROLE.USR2));
• This command adds a connection rule that requires the client session to originate from the
QtrReport.exe application, to have the user logged in as ROLE.USR3, and to use a data
source named DS1:
ADD RULE CONN CONNRULE3 (APPL QtrReport.exe, LOGIN ICASE(ROLE.USR3),
DSN ICASE(DS1));
• This command adds a connection rule that requires the client session to originate from the
Quarterly Report application, to have the user logged in as ROLE.USR3, and to use a
data source named DS1:
ADD RULE CONN CONNRULE4 (APPL "Quarterly Report", LOGIN ICASE(ROLE.USR3),
DSN ICASE(DS1));
• This command adds a connection rule that requires the client session to be an NCI session
and to use a data source named DS1:
ADD RULE CONN CONNRULE22 (APPL ICASE(NCI), DSN ICASE(DS1), WARN-LOW,
SQL_CMD "SET SCHEMA SALES; SET TRANSACTION ISOLATION LEVEL READ
UNCOMMITTED;");
When this connection rule evaluates to true, the SET SCHEMA and SET TRANSACTION
statements set the schema and isolation level, respectively, for the client session, and the
warning level is set to low for queries running in the associated service.
• This command adds a connection rule that has multibyte characters:
ADD RULE CONN (APPL ICASE(NCI), DSN ICASE(DS1), WARN-LOW,
SQL_CMD "SET SCHEMA " "; SET TRANSACTION ISOLATION LEVEL READ
UNCOMMITTED;");
If an identifier in the SQL command contains multibyte characters, you must delimit the
identifier in double quotes. However, you do not need to put the name of the rule in double
quotes if it contains multibyte characters.
• This command adds a connection rule that causes the query statistics for INSERT statements
to be aggregated:
ADD RULE CONN CONNRULE5 (SESSION ICASE(JOB3050), AGGREGATE QUERY_TYPE INSERT);
• This command adds a connection rule that causes the query statistics for INSERT, UPDATE,
and DELETE statements to be aggregated:
ADD RULE CONN CONNRULE6 (SESSION ICASE(JOB3060), AGGREGATE QUERY_TYPE (INSERT,
UPDATE, DELETE));
• This command adds a connection rule that causes the query statistics for INSERT, UPDATE,
and DELETE statements to be aggregated and specifies additional aggregation parameters:
ADD RULE CONN CONNRULE7 (SESSION ICASE(JOB3070), AGGREGATE (QUERY_TYPE (INSERT,
UPDATE, DELETE), REPOS_INTERVAL 4, WMS_INTERVAL 3, EXEC_INTERVAL 1));
The REPOS_INTERVAL parameter causes the NDCS server to update the Neoview
Repository every four minutes with the aggregated statistics, and the WMS_INTERVAL
causes the NDCS server to update WMS every three minutes with the latest aggregated
statistics for display. The EXEC_INTERVAL specifies that the maximum execution time of
the query is expected to be one minute or less. If the execution time of the query is longer
than one minute, the NDCS server does not aggregate the query statistics but instead saves
the individual statistics from each execution of the query in the Repository.
ADD RULE CONN Command 181