Neoview Workload Management Services Guide (R2.4)

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 connection rules and services, including associations for the predefined “HPS_”
rules and services.
NOTE: Only administrators are permitted to run this command. By default, an administrator
is ROLE.DBA or the super ID (super.services or super.super).
Syntax
ALTER WMS CONN conn-rule-list
conn-rule-list is:
( [ conn-rule-list-member [, conn-rule-list-member ]... ])
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.
Considerations
• Each time you run the ALTER WMS CONN command, do not forget to add the associations
for the predefined “HPS_” rules and services before adding the associations for your
user-defined rules and services. For more information, see “How to Retain Connection Rule
and Service Associations” (page 47).
Examples
• This command associates connection rules with existing services:
alter wms conn (
HPS_TRANSPORTER1 HPS_TRANSPORTER,
HPS_MANAGEABILITY1 HPS_MANAGEABILITY,
HPS_MANAGEABILITY2 HPS_MANAGEABILITY,
HPS_MANAGEABILITY3 HPS_MANAGEABILITY,
HPS_MANAGEABILITY4 HPS_MANAGEABILITY,
HPS_MANAGEABILITY5 HPS_MANAGEABILITY,
HPS_MANAGEABILITY6 HPS_MANAGEABILITY,
HPS_MANAGEABILITY7 HPS_MANAGEABILITY,
HPS_MANAGEABILITY8 HPS_MANAGEABILITY,
HPS_MANAGEABILITY9 HPS_MANAGEABILITY,
(CONNRULE1, CONNRULE2) SERVICE1
);
108 WMS Commands