create tempdbspace from storagepool argument: Create a temporary dbspace from the storage pool (SQL administration API)

Use the create tempdbspace from storagepool argument with the admin() or task() function to create a temporary dbspace from an entry from the storage pool.


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

>--"--create--+-------------+--tempdbspace from storagepool--"-->



Element Description Key Considerations
initial_chunk_size The size, in kilobytes, of the initial chunk of the new temporary dbspace. See admin() and task() Argument Size Specifications.
page_size The non-default page size, in kilobytes, for the new temporary dbspace. The page size is optional.
tempdbspace The name of the temporary dbspace.  

Use the create unencrypted tempdbspace from storagepool argument to create an unencrypted temporary dbspace when encryption is enabled by the DISK_ENCRYPTION configuration parameter.


The following command creates a temporary dbspace named tempdbspace1. The new dbspace has a size of 1 gigabyte and a page size of 12 kilobytes.

EXECUTE FUNCTION task("create tempdbspace from storagepool", "tempdbspace1",
 "1 GB", "12");

Copyright© 2018 HCL Technologies Limited