set chunk argument: Change the status of a chunk (SQL administration API)

Use the set chunk argument with the admin() or task() function to change the status of a blobspace, dbspace, or sbspace to online or offline.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(--+-"set chunk offline"-+------>
                     '-task--'     '-"set 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. 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 set chunk offline argument to change the status of the chunk to offline.

Use the set chunk online argument to change the status of the chunk to online.

This function is equivalent to the onspaces -s command.

Example

The following example changes the status of a chunk to online:
EXECUTE FUNCTION task("set chunk online","dbs1","/dev/raw_dev1","0");
     Database selected. 

(expression)  Chunk status successfully changed. 
              Chunk number 2 "/dev/raw_dev1" -- Online 

1 row(s) retrieved.

Copyright© 2019 HCL Technologies Limited