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.


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




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.  


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.


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",

Copyright© 2018 HCL Technologies Limited