Home | Previous Page | Next Page   Utility Reference > onutil: Check, Define, and Modify Storage Objects > ALTER DBSLICE ADD DBSPACE >

Adding Mirrored Dbspaces to a Dbslice

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
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]