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

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

Syntax

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

>--,--"--drop sbspace to storagepool--"--"sbspace"--)--;-------><

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

Example

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

EXECUTE FUNCTION task("drop sbspace to storagepool", "sbspace8");

Copyright© 2018 HCL Technologies Limited