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

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

Syntax

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

>--"--drop tempsbspace to storagepool--"--,--"tempsbspace"------>

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

Element Description Key Considerations
tempsbspace The name of the empty temporary sbspace.  

Example

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

EXECUTE FUNCTION task("drop tempsbspace to storagepool", "tempsbspace3");

Copyright© 2019 HCL Technologies Limited