CREATE COGROUP

>>-CREATE COGROUP--+-cogroup_name-----------------+--FROM------->
                   '-| Cogroup_Range_Identifier |-'

   .-,---------------------------------.
   V                                   |
>----+-| Coserver_Range_Identifier |-+-+-----------------------><
     '-coserver_name-----------------'

Cogroup_Range_Identifier:

|--+-prefix--| Formatting Characters |---------+----------------|
   '-prefix--| Formatting Characters |--suffix-'

Coserver_Range_Identifier:

|--dbservername--.--| Formatting Characters |-------------------|

Formatting Characters:

|--%r--(--first--..--last--)------------------------------------|

Element	Purpose	Restrictions	Syntax
cogroup_name	The name of the new cogroup in the database server	Name must be unique within a database server.	See Cogroup Name.
coserver_name	The name of a coserver that the database server automatically generates	Name must have the following format: dbservername.number The dbservername must be the same value that the DBSERVERNAME configuration parameter specifies. The number must be one of the integers that the COSERVER configuration parameter specifies.	See Coserver Name.
prefix	The alphabetic portion of the generated cogroup name that precedes the formatting character	The combination of the prefix, formatting character, and suffix must not exceed 18 characters.	See Pathname Format and Coserver List.
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 and Coserver List.
dbservername	The name of the database server	You must use the same value that the DBSERVERNAME configuration parameter specifies.	See DBSERVERNAME.
first	The starting integer value to substitute in a cogroup or coserver name	The value of first must be equal to or less than last. When first is in the COGROUP clause, its value can be any integer that makes the cogroup name unique. When last is in a FROM clause, it must be one of the values that the COSERVER configuration parameter specifies.	This value must be an unsigned integer.
last	The ending integer value to substitute for the cogroup or coserver name	The value of last must be equal to or larger than first. When last is in the COGROUP clause, its value can be any integer that makes the cogroup name unique. When last is in a FROM clause, it must be one of the values that the COSERVER configuration parameter specifies.	This value must be an unsigned integer.

You must create a cogroup before you can create a dbslice. Use the onutil CREATE COGROUP command to create a new group of coservers in your database server. Cogroups make managing coservers simpler. Instead of specifying a long list of coservers in onutil commands, you specify a cogroup name.

The following examples assume that your ONCONFIG file contains the configuration parameters shown in Figure 83, an excerpt of a sample ONCONFIG file that configures an Extended Parallel Server database server and 16 coservers.

Figure 83. Excerpt of Sample ONCONFIG File

DBSERVERNAME eds   

ROOTSLICE    rootdbs   
ROOTPATH     /work/dbspaces/rootdbs_%c   
ROOTOFFSET   0   
ROOTSIZE     40000   

MIRRORSLICE  mirror   
MIRRORPATH   /work/dbspaces/mirror_%c   
MIRROROFFSET 0   
MIRROR       1    # 1 = yes      

PHYSSLICE    rootdbs   
PHYSDBS      physdbs_%c   
PHYSSIZE     8000   

LOGFILES     3   
LOGSIZE      1000   
...
COSERVER     1   
    NODE     NODE1   
   ...
END
...
COSERVER    16   
    NODE    NODE16   
   ...
END

CREATE COGROUP

Syntax

Usage