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.


Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(------------------------------->

>--"--create--+-------------+--tempsbspace from storagepool--"-->


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.


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");

Copyright© 2018 HCL Technologies Limited