Adding Dbspaces on a New Coserver to a Dbslice

The following example shows the onutil CREATE COGROUP command to create a cogroup for three coservers and the onutil CREATE DBSLICE command to create a dbslice that contains six dbspaces numbered dbsl.1 through dbsl.6:

% onutil
1> CREATE COGROUP c123 FROM eds.%r(1..3)
Cogroup successfully created.
2> CREATE DBSLICE dbsl FROM COGROUP c123
3> CHUNK "/dev/dbspaces/dbsl_123.%r(1..2)" SIZE 1024;

The database server creates the following dbspaces on the three coservers. The %r(first..last) formatting characters tell the database server to create two dbspace chunks on coservers eds.1 through eds.3.

Then you add a new coserver, eds.4, to the system and want to expand the dbslice to that coserver. The following example shows the onutil ALTER DBSLICE ADD DBSPACE command to add dbspaces dbsl.7 and dbsl.8 to coserver eds.4. The new dbspaces can be either the same size as the old dbspaces in the dbslice or a different size.

% onutil
1> ALTER DBSLICE dbsl ADD DBSPACE FROM
2> COGROUP eds.4
3> CHUNK "/dev/dbspaces/dbsl_4.%r(1..2)" SIZE 1024;

The range identifier %r(1..2) tells the database server to create two dbspaces on coserver eds.4 and automatically numbers them.