You can create nonuniform dbslices when you use multiple dbslice components in the FROM clause of the onutil CREATE DBSLICE command.
The following examples show the onutil CREATE COGROUP command to create a cogroup for eight coservers and the onutil CREATE DBSLICE command to create a nonuniform dbslice for this cogroup and the default cogroup_all that contains sixteen coservers:
% onutil 1> CREATE COGROUP acctg_cogroup 2> FROM eds.%r(1..8); Cogroup successfully created. 3> CREATE DBSLICE dbsl 4> FROM COGROUP acctg_cogroup 5> CHUNK "/dev/dbsl_acctg" 6> SIZE 2056, 7> COGROUP cogroup_all 8> CHUNK "/dev/dbsl_all" 9> OFFSET 1024 SIZE 1024;
This example assumes the coserver numbers in the ONCONFIG file shown in Figure 83 and generates the following dbspace names and pathnames.
Coserver | Dbspace Name | Chunk | Offset |
---|---|---|---|
eds.1 | dbsl.1 | /dev/dbsl_acctg | 0 |
eds.2 | dbsl.2 | /dev/dbsl_acctg | 0 |
... | |||
eds.8 | dbsl.8 | /dev/dbsl_acctg | 0 |
eds.9 | dbsl.9 | /dev/dbsl_all | 1024 |
eds.10 | dbsl.10 | /dev/dbsl_all | 1024 |
... | |||
eds.16 | dbsl.16 | /dev/dbsl_all | 1024 |