Neoview Workload Management Services Guide (R2.4)

The connection attributes of the client session must match all the connection attribute expressions
in the connection rule for the connection rule to be considered true.
Connection Attributes in a Client Application
Table 4-1 shows the methods for setting connection attributes in a client application.
Table 4-1 Methods for Setting Connection Attributes in a Client Application
.NETODBCJDBC
Connection
Attribute
same as ODBCSQL_ATTR_SESSIONNAME
sessionName property
Session name
same as ODBCSQL_ATTR_APPLNAME
applicationName
property
Application name
same as ODBCSet during loginSet during loginClient login role
same as ODBCSet in the Microsoft ODBC
Administrator or the DSN
connection string
serverDataSource
property
Data source name
For more information, see the Neoview ODBC Drivers Manual or the Neoview JDBC Type 4 Driver
Programmer's Reference.
Connection Attribute Expressions in a Connection Rule
Each expression must be separated by a comma in the ADD RULE CONN command. The NDCS
server evaluates the expressions in the order you specify them in the ADD RULE CONN
command. When the connection attributes of the client session match all the expressions in the
connection rule, the connection rule evaluates to true, and the NDCS server assigns the client
session to the service associated with the connection rule.
This ADD RULE CONN command defines a connection rule that has four connection attribute
expressions specifying the session, application, client login role, and data source:
ADD RULE CONN CONNRULE3 (SESSION JOB2510, APPL QtrReport.exe, LOGIN ROLE.USR3,
DSN ICASE(DSN1));
This ADD RULE CONN command defines a connection rule that has one connection attribute
expression that specifies that the application name must be NCI (for the Neoview Command
Interface):
ADD RULE CONN CONNRULE23 (APPL NCI);
The NDCS server assigns an NCI session to the service associated with the connection rule,
CONNRULE23.
Case Sensitivity, ICASE, and Delimiting String Values
The string values for each connection attribute expression are case-sensitive by default. You do
not need to delimit the string values in double quotes, except when there are spaces in the string
value. If you want the NDCS server to ignore the case during the comparison of the client session
and connection rule, use the ICASE() function, as this example shows:
ADD RULE CONN CONNRULE4 (APPL "Quarterly Report", LOGIN ROLE.USR4, DSN ICASE(DSN1));
For the syntax, see the “ADD RULE CONN Command” (page 86).
Specifying a Warning Level for the Connection Rule
In a connection rule, the warning level is set to NO-WARN by default, meaning that WMS does
not set the warning level or save warning information when the connection rule evaluates to
true. If you want to save warning information when a connection rule evaluates to true, set the
warning level of the connection rule to WARN-LOW. This ADD RULE CONN command specifies
WARN-LOW for the warning level of a connection rule:
Connection Rules 43