alter chunk argument: Change chunk status to online or offline (SQL administration API)
Use the alter chunk argument with the admin() or task() function to bring a chunk online or take a chunk offline in a dbspace, blobspace, or sbspace.
Syntax
| Element | Description | Key Considerations |
|---|---|---|
| space_name | The name of the blobspace, dbspace, or sbspace. | |
| path_name | The disk partition or unbuffered device of the chunk. | |
| offset | The offset (in kilobytes) into the disk partition or unbuffered device to reach the chunk. The default is 0. | See admin() and task() Argument Size Specifications. |
Usage
The chunk must be in a mirrored pair, or a non-primary chunk within a noncritical dbspace.
Use the alter chunk online argument to change the chunk status to online.
Use the alter chunk offline argument to change the chunk status to offline.
This function is equivalent to the onspaces -s command.
Example
The following example
brings a chunk in a space named dbspace4 online:
EXECUTE FUNCTION task("alter chunk online","dbspace4","/dev/raw_dev1","0");