create blobspace from storagepool argument: Create a blobspace from the storage pool (SQL administration API)
Use the create blobspace from storagepool argument with the admin() or task() function to create a blobspace from an entry from the storage pool.
Syntax
EXECUTE FUNCTION
{
admin
| task
}
(
"
create
[unencrypted]
blobspace from storagepool
"
,
"blobspace",
"initial_chunk_size",
[ ,"blobpage_size"
[ ,"mirroring_flag"
]
]
);
| Element | Description | Key Considerations |
|---|---|---|
| blobspace | The name of the blobspace. | The blobspace 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. |
| blobpage_size | The blobpage size, specified in terms of page_unit, the number of disk pages per blobpage | The page size is optional. However if you specify 1 for
mirroring, you must also specify a page size. |
| initial_chunk_size | The size, in kilobytes, of the initial chunk of the new blobspace. | See admin() and task() Argument Size Specifications. |
| mirroring_flag | Either:
|
The mirroring flag is optional. |
Use the create unencrypted blobspace from storagepool argument to create an unencrypted blobspace when encryption is enabled by the DISK_ENCRYPTION configuration parameter.
Examples
The following command creates a
mirrored blobspace named blobspace1. The new blobspace
has a size of 100 gigabytes and a blobpage size of 100 pages.
EXECUTE FUNCTION task("create blobspace from storagepool", "blobspace1", "100 GB",
"100", "1");The following command creates an unmirrored
blobspace named blobspace2 with the default blobpage
size, so a blobpage size is not specified:
EXECUTE FUNCTION task("create blobspace from storagepool", "blobspace2", "5000");