Neoview Workload Management Services Guide (R2.5)

Connection Rules
Connection rules determine which service to assign to the client session. Because connection
rules are the mechanism for assigning queries to services, you must create connection rules and
associate them with services if you plan to use the services that you created to manage query
workloads.
This section covers:
• “How the NDCS Server Evaluates Connection Rules” (page 70)
• “Display the Connection Rules Summary” (page 73)
• “Add a Connection Rule” (page 74)
• “Alter a Connection Rule” (page 80)
• “Delete a Connection Rule” (page 82)
• “Associate Connection Rules With a Service” (page 83)
How the NDCS Server Evaluates Connection Rules
When a client application connects to an NDCS server, the NDCS server retrieves the connection
rules from WMS and compares them with the client's connection attributes, set in ODBC, JDBC,
or .NET, to determine which service to assign to the client session.
The connection rules determine the service to assign to the client session based on one or more
of these connection attributes:
• Session name (SESSION)
• Application name (APPL)
• Client login role (LOGIN)
• Data source name (DSN)
The NDCS server evaluates each connection rule in the order in which you have associated the
connection rules with services. The NDCS server evaluates the first connection rule in the series
by comparing the connection attributes of the client session with the connection attribute
expressions defined in the connection rule. The connection attributes of the client session must
match all the connection attribute expressions defined in the connection rule for the NDCS server
to consider the connection rule to be true. If any of the connection attributes of the client session
do not match the connection attribute expressions defined in the connection rule, the NDCS
server considers the connection rule to be false and checks the next connection rule in the series.
For an example, see Figure 5-1 (page 71).
70 Configuring Rules