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

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(------------------------------->
                     '-task--'      

>--"add mirror"--,--"space_name"--,--"path_name"--,------------->

>--"offset"--,--"mirror_path"--,--"mirror_offset"--)--;--------><

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");

Copyright© 2019 HCL Technologies Limited