Coserver List

Home | Previous Page | Next Page Utility Reference > onutil: Check, Define, and Modify Storage Objects > Identifiers in onutil Commands >

Coserver List

The coserver_list specifies one or more coserver names to define as members of a cogroup.

Syntax

Coserver_List:

                     .-,----------------------------.
                     V                              |
|--"--prefix--+---+----+--------------------------+-+----------->
              '-.-'    +-%c-----------------------+
                       +-%n-----------------------+
                       +-%o-----------------------+
                       '-%f--(--first--"--last--)-'

>--+--------+--"------------------------------------------------|
   '-suffix-'

Element	Purpose	Restrictions	Syntax
prefix	The alphabetic portion of the generated cogroup name that precedes the formatting character	Each coserver name that is matched by the combination of the prefix, formatting character, and suffix must not exceed 18 characters.	See Identifiers in onutil Commands.
%c	A formatting character that onutil replaces with the coserver number for each coserver in the list of coservers	The coserver number is the value that you specified in the COSERVER configuration parameter for this coserver.	See Identifiers in onutil Commands.
%n	A formatting character that onutil replaces with the host name of the node for each coserver in the generated list of coservers	The host name is the value that you specified in the NODE configuration parameter for this coserver.	See Identifiers in onutil Commands.
%o	A formatting character that onutil replaces with the ordinal number of each coserver in the generated list of coservers	None.	See Identifiers in onutil Commands.
%r	A formatting character that indicates a range of successive integer values bounded by first and last inclusively	Numbers within the range that fall outside of the ordinal range of existing coservers are ignored.	See Identifiers in onutil Commands.
first	The starting integer value to substitute in a coserver name	This value must be a smaller integer than last. When last is in a FROM clause, it must be one of the values that is specified in the COSERVER configuration parameter.	This value must be an unsigned integer.
last	The ending integer value to substitute for the coserver name	This value must be equal to or larger than first. When last is in a FROM clause, it must be one of the values that is specified in the COSERVER configuration parameter.	This value must be an unsigned integer.
suffix	The alphabetic portion of the generated cogroup name that follows the formatting character	The combination of the prefix, formatting character, and suffix must not exceed 18 characters.	See Identifiers in onutil Commands.

Usage

Use the coserver_list identifier to list coservers that can be included in a range. Use a coserver list identifier in the same onutil commands that use the coserver range identifier on page Coserver List. For a description of a coserver name, see Coserver Name.

For example, to include coservers eds.1, eds.3, and eds.7, you can list several coserver names. The following onutil command creates cogroups acctg_cogroup and sales_cogroup from a list of coservers:

% onutil
1> CREATE COGROUP acctg_cogroup 
2> CREATE COGROUP sales_cogroup
3> FROM eds.1, eds.3, eds.7;