Neoview Workload Management Services Guide (R2.5)

5 Configuring Rules
“What Are Rules?” (page 69)
“Global Rule Considerations” (page 69)
“Connection Rules” (page 70)
“Compilation Rules” (page 84)
“Execution Rules” (page 98)
“Display the Rules Summary” (page 112)
Associate Rules With Services” (page 114)
“Display the Services Associated With a Rule” (page 118)
“Display the Rules Associated With a Service” (page 119)
NOTE: The tasks in this chapter require you to be an administrator. For more information, see
Assign Administrators” (page 39).
What Are Rules?
Rules allow you, the administrator, to specify conditions for WMS to evaluate and trigger actions
during certain phases of the client session and query execution:
When a client application connects to an NDCS server, the NDCS server compares the
connection rules in WMS with the client's connection attributes to determine which WMS
service to assign to the client session and the queries running in it.
After a query is prepared, WMS validates the compiler estimates of the query against the
compilation rules set for the service and, along with other criteria, determines whether to
permit the query to start executing.
When a query has been executing for a configured interval (by default, five minutes), WMS
starts periodically checking the execution rules set for the service and comparing them with
the query runtime statistics to determine whether the query can continue executing.
The next sections describe how to establish these types of user-defined rules in WMS:
“Connection Rules” (page 70)
“Compilation Rules” (page 84)
“Execution Rules” (page 98)
NOTE: You can configure rules using the NPA Tools—the Neoview Performance Analyzer or
the Neoview Query Viewer—or using WMS commands. This chapter provides instructions on
how to configure rules using the NPA Tools and refers to the WMS commands in Appendix A
(page 171).
Global Rule Considerations
The following considerations apply to creating all types of rules in WMS:
Rule names must be unique. No rule, whether it is a connection, compilation, or execution
rule, can have the same name as another rule.
You can define a maximum of 1000 rules.
You can assign a maximum of 100 rules to a service.
You cannot have more than 988 rule-to-service associations.
What Are Rules? 69