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


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");