Creating User-Defined Cogroups

For example, you can create your own cogroup that includes all of the specific-purpose coservers so that you can create temporary dbslices across all of them. To create such a cogroup, you might enter the following onutil command to create a cogroup called cogroup_special from coservers 4 through 6 on the sales database server, which have been configured with either TEMPDATA or COMPUTE capabilities:

onutil CREATE COGROUP cogroup_special FROM sales.%r(4..6);

To make sure that at least some dbspaces created from this cogroup are always available for temporary tables, even if the specific-purpose coservers are disabled, you might include one or more of the fully capable coservers in the definition of the cogroup.