create chunk argument: Create a chunk (SQL administration API)

Use the create chunk argument with the admin() or task() function to create a chunk in a dbspace or in a blobspace.

Syntax

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

>--"create--+------------+--chunk"--,--"space_name"--,--"path_name"-->
            '-with_check-'                                            

>--+-------------------------------------------------------------------------------+-->
   '-,--"disk_size"--+-----------------------------------------------------------+-'   
                     '-,--"offset"--+------------------------------------------+-'     
                                    '-,--"mirror_path"--+--------------------+-'       
                                                        '-,--"mirror_offset"-'         

>--)--;--------------------------------------------------------><

Element Description Key Considerations
disk_size The amount of disk space to add in kilobytes. See admin() and task() Argument Size Specifications.
mirror_offset The location of the mirror chunk.  
mirror_path The path to the mirror chunk. If you are adding a chunk to a mirrored storage space, you must also add a mirror chunk.  
offset The location of the new chunk.  
path_name The path of the added disk space.  
space_name The name of the dbspace, blobspace, or sbspace to which you are adding disk space.  

Usage

Use the create with_check chunk argument to check the specified path name and return an error if it does not exist.

This function is equivalent to the onspaces -a command.

Example

The following example adds a 5 MB chunk of raw disk space, at an offset of 5200 kilobytes, to a dbspace named dbspc3:
EXECUTE FUNCTION task("create chunk", "dbspc3","\\.\e:","5120","5200");
The following example adds a 10 MB mirror chunk to a blobspace named blobsp3 with an offset of 200 kilobytes for both the primary and mirror chunks:
EXECUTE FUNCTION task("create with_check chunk","blobsp3","/dev/raw_dev1","10240",
"200","/dev/raw_dev2","200");

Copyright© 2019 HCL Technologies Limited