You can mirror chunks in your dbslice when you use the MIRROR option in the onutil CREATE DBSLICE command. Specify mirror chunk pathnames in the same way as for a primary chunk, including the use of formatting characters.
The following example shows the onutil CREATE DBSLICE command to create mirror dbspaces on each coserver in the acctg_cogroup cogroup:
% onutil 1> CREATE DBSLICE acctg_sl 2> FROM COGROUP acctg_cogroup 3> CHUNK "/dev/dbsl_acctg.%r(1..2)" 4> OFFSET 1024 SIZE 1024 5> MIRROR "/dev/mirr_dbsl_acctg.%r(1..2)";
The database server creates the following dbspaces on the eight coservers.
Coserver | Dbspace Identifier | Primary or Mirror Chunk | Offset |
---|---|---|---|
eds.1 | acctg_sl.1 | /dev/dbsl_acctg.1 | 1024 |
eds.1 | /dev/mirr_dbsl_acctg.1 | 0 | |
eds.1 | acctg_sl.2 | /dev/dbsl_acctg.2 | 1024 |
eds.1 | /dev/mirr_dbsl_acctg.2 | 0 | |
eds.2 | acctg_sl.3 | /dev/dbsl_acctg.1 | 1024 |
eds.2 | /dev/mirr_dbsl_acctg.1 | 0 | |
eds.2 | acctg_sl.4 | /dev/dbsl_acctg.2 | 1024 |
eds.2 | /dev/mirr_dbsl_acctg.2 | 0 | |
... | |||
eds.8 | acctg_sl.15 | /dev/dbsl_acctg.1 | 1024 |
eds.8 | /dev/mirr_dbsl_acctg.1 | 0 | |
eds.8 | acctg_sl.16 | /dev/dbsl_acctg.2 | 1024 |
eds.8 | /dev/mirr_dbsl_acctg.2 | 0 |