add mirror argument: Add a mirror chunk (SQL administration API)
Use the add mirror argument with the admin() or task() function to add a mirror chunk to a dbspace.
Syntax
Element | Description | Key Considerations |
---|---|---|
mirror_path | The disk partition or unbuffered device of the initial chunk of the dbspace, blobspace, or sbspace that performs the mirroring. | |
mirror_offset | The offset to reach the mirrored chunk of the newly mirrored dbspace, blobspace, or sbspace. | See admin() and task() Argument Size Specifications. |
offset | The offset into the disk partition or into the unbuffered device in kilobytes to reach the initial chunk of the newly mirrored dbspace, blobspace, or sbspace. | See admin() and task() Argument Size Specifications. |
path_name | The disk partition or unbuffered device of the initial chunk of the dbspace, blobspace, or sbspace that you want to mirror. | |
space_name | The name of a dbspace, blobspace, or sbspace to mirror. |
Usage
This function is equivalent to the onspaces -m command.
Example
The following example adds a mirror chunk to a blobspace named blobsp3:
EXECUTE FUNCTION task("add mirror","blobsp3","/dev/raw_dev1",
"10240","/dev/raw_dev2","200");