Neoview Workload Management Services Guide (R2.5)

ALTER WMS CONN Command
The ALTER WMS CONN associates connection rules with services.
CAUTION: Each time you enter an ALTER WMS CONN command, you overwrite existing
associations of user-defined connection rules and services. However, the associations of the
predefined HPS rules and services are preserved.
To avoid overwriting the existing associations of user-defined connection rules and services,
either specify all the new and existing user-defined associations in the ALTER WMS CONN
command or use the Neoview Performance Analyzer or the Neoview Query Viewer to establish
new associations of connection rules with services.
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 WMS CONN conn-rule-list
conn-rule-list is:
( [ conn-rule-list-member [, conn-rule-list-member ]... | RESET ] )
conn-rule-list-member is:
[(] rule-name [ , rule-name ]... [)] service-name
rule-name
is the name of an existing connection rule. The order of the rules in the
conn-rule-list-member is the order in which WMS evaluates the rules.
service-name
is the name of an existing service for managing queries.
RESET
removes the associations between the user-defined connection rules and services but does
not remove the associations between the predefined “HPS_” rules and services.
Considerations
• Each time you run the ALTER WMS CONN command, do not forget to add the associations
for existing user-defined rules and services before adding the associations for your
user-defined rules and services.
• Specifying empty parentheses removes the associations between the user-defined connection
rules and services and has same effect as the RESET option:
alter wms conn ( );
• 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 connection rules with an existing service:
ALTER WMS CONN ( (CONNRULE1, CONNRULE2) SERVICE1 );
206 WMS Commands