create tempsbspace from storagepool argument: Create a temporary sbspace from the storage pool (SQL administration API)
Use the create tempsbspace from storagepool argument with the admin() or task() function to create a temporary sbspace from an entry from the storage pool.
Syntax
EXECUTE FUNCTION
{
admin
| task
}
(
"
create
[unencrypted]
tempsbspace from storagepool
"
,
"tempsbspace",
"initial_chunk_size"
);
| 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. |
| tempsbspace | The name of the temporary sbspace. | The temporary 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. |
Use the create unencrypted tempsbspace from storagepool argument to create an unencrypted temporary sbspace when encryption is enabled by the DISK_ENCRYPTION configuration parameter.
Example
The following command creates a
temporary sbspace named tempsbspace5. The temporary
sbspace has a size of 240 megabytes.
EXECUTE FUNCTION task("create tempsbspace from storagepool",
"tempsbspace5", "240 MB");