Neoview Workload Management Services Guide (R2.5)

ALTER SERVICE COMP Command
The ALTER SERVICE COMP command associates compilation rules with a service.
NOTE: Only administrators are permitted to run this command. By default, an administrator
is a user associated with ROLE.DBA, SUPER.SERVICES, or SUPER.SUPER.
Syntax
ALTER SERVICE service-name COMP rule-list
rule-list is:
( [ rule-name [ , rule-name ... ] | RESET ] )
service-name
is the name of an existing service for managing queries. service-name must exist in the
WMS configuration and cannot be the SYSTEM service.
rule-name
is the name of an existing compilation rule. The order of the rules in the rule-list is the
order in which WMS evaluates the rules.
RESET
removes the association between the user-defined compilation rules and the service.
Considerations
• Specifying empty parentheses removes the association between the user-defined compilation
rules and the service and has same effect as the RESET option:
alter service service1 comp ( );
• You can assign a maximum of 100 rules to a service.
• You cannot have more then 988 rule-to-service associations.
Example
This command associates the compilation rules, COMPRULE1, COMPRULE2, and COMPRULE3,
with SERVICE1.
ALTER SERVICE SERVICE1 COMP (COMPRULE1, COMPRULE2, COMPRULE3);
202 WMS Commands