create sbspace from storagepool argument: Create an sbspace from the storage pool (SQL administration API)
Use the create sbspace from storagepool argument with the admin() or task() function to create an sbspace from an entry from the storage pool.
Syntax
| Element | Description | Key Considerations |
|---|---|---|
| sbspace | The name of the sbspace. | The sbspace name must be unique and cannot exceed
128 bytes. It must begin with a letter or underscore and must contain
only letters, numbers, underscores, or the $ character. |
| initial_chunk_size | The size, in kilobytes, of the initial chunk of the new sbspace. | See admin() and task() Argument Size Specifications. |
| logging_flag | Either:
|
The logging flag is optional. However if you
specify 1 for mirroring, you must also specify a
logging flag. |
| mirroring_flag | Either:
|
The mirroring flag is optional. |
Use the create unencrypted sbspace from storagepool argument to create an unencrypted sbspace when encryption is enabled by the DISK_ENCRYPTION configuration parameter.
Examples
The following command creates a
mirrored and logged sbspace named sbspace1. The new
sbspace has a size of 240 megabytes.
EXECUTE FUNCTION task("create sbspace from storagepool", "sbspace1",
"240 MB", "1", "1");The following command creates
an unmirrored and unlogged sbspace named sbspace2.
This sbspace has a size of 5 gigabytes.
EXECUTE FUNCTION task("create sbspace from storagepool", "sbspace2", "5 GB");