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.


Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(--+-"alter chunk offline"-+---->
                     '-task--'     '-"alter chunk online"--'   

>--,--"space_name"--,--"path_ name"--,--"offset"--)--;---------><

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.


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.


The following example brings a chunk in a space named dbspace4 online:

EXECUTE FUNCTION task("alter chunk online","dbspace4","/dev/raw_dev1","0");

Copyright© 2018 HCL Technologies Limited