Suppose you have a database server that is using mirroring with two coservers. The following example shows the onutil CREATE DBSLICE command to create mirrored dbspaces on each coserver:
% onutil 1> CREATE DBSLICE dbsl FROM COGROUP cogroup_all 2> CHUNK "/disk3/dbspace/dbsl.%c" SIZE 500 MBYTES 3> MIRROR "/disk4/dbspace/dbsl_mir.%c";
The database server creates the mirrored dbspaces on the coservers.
Coserver | Dbspace | Primary Chunk | Mirror Chunk |
---|---|---|---|
eds.1 | dbsl.1 | /disk3/dbspace/dbsl.1 | /disk4/dbspace/dbsl_mir.1 |
eds.2 | dbsl.2 | /disk3/dbspace/dbsl.2 | /disk4/dbspace/dbsl_mir.2 |
The following example shows the onutil ALTER DBSLICE ADD DBSPACE command with the MIRROR option to add mirrored dbspaces to dbslice dbsl on each coserver:
% onutil 1> ALTER DBSLICE dbsl ADD DBSPACE 2> FROM COGROUP cogroup_all 3> CHUNK "/disk3/dbspace/dbsl2.%c" SIZE 1000 MBYTES 3> MIRROR "/disk4/dbspace/dbsl_mir2.%c";
The database server adds mirrored dbspaces to the dbslice on both coservers.
Coserver | Dbspace | Primary Chunk | Mirror Chunk |
---|---|---|---|
eds.1 | dbsl.1 | /disk3/dbspace/dbsl.1 | /disk4/dbspace/dbsl_mir.1 |
eds.2 | dbsl.2 | /disk3/dbspace/dbsl.2 | /disk4/dbspace/dbsl_mir.2 |
eds.1 | dbsl.3 | /disk3/dbspace/dbsl2.1 | /disk4/dbspace/dbsl_mir2.1 |
eds.2 | dbsl.4 | /disk3/dbspace/dbsl2.2 | /disk4/dbspace/dbsl_mir2.2 |