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
EXECUTE FUNCTION
{
admin
| task
}
(
"create [with_check]
chunk",
"space_name",
"path_name"
[ ,
"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");EXECUTE FUNCTION task("create with_check chunk","blobsp3","/dev/raw_dev1","10240",
"200","/dev/raw_dev2","200");