drop tempdbspace to storagepool argument: Return space from an empty temporary dbspace to the storage pool (SQL administration API)

Use the drop tempdbspace to storagepool argument with the admin() or task() function to return the space from an empty temporary dbspace to the storage pool.

Syntax

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

>--"--drop tempdbspace to storagepool--"--,--"tempdbspace"------>

>--)--;--------------------------------------------------------><

Element Description Key Considerations
tempdbspace The name of the empty temporary dbspace.  

Example

The following command drops an empty temporary dbspace named tempdbs1 and adds all of the freed space to the storage pool.

EXECUTE FUNCTION task("drop tempdbspace to storagepool", "tempdbs1");

Copyright© 2019 HCL Technologies Limited