create sbspace argument: Create an sbspace (SQL administration API)
Use the create sbspace argument with the admin() or task() function to create an sbspace.
Syntax
EXECUTE FUNCTION
{
admin
| task
}
(
"create
{
[unencrypted]
| [with_check]
}
sbspace"
,
"sbspace"
,
"path_name"
[ ,"initial_chunk_size"
[ ,"offset"
]
]
);
| Element | Description | Key Considerations |
|---|---|---|
| initial_chunk_size | The size, in kilobytes, of the initial chunk of the new sbspace. | See admin() and task() Argument Size Specifications. |
| offset | The offset, in kilobytes, into the disk partition or into the device to reach the initial chunk of the new sbspace. | |
| path_name | The disk partition or unbuffered device of the initial chunk of the sbspace. | |
| sbspace | The name of the sbspace to be created. |
Usage
Use the create with_check sbspace argument to check the specified path name and return an error if it does not exist.
Use the create unencrypted sbspace argument to create an unencrypted sbspace when encryption is enabled by the DISK_ENCRYPTION configuration parameter.
This function is equivalent to the onspaces -c -S command.
Example
The following example creates a new sbspace that has a size of 20 MB with an offset of 0:
EXECUTE FUNCTION task ("create sbspace","sbspace2",
"$INFORMIXDIR/WORK/sbspace2","20 M","0");