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

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

Syntax

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

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

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

Example

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

EXECUTE FUNCTION task("drop dbspace to storagepool", "dbs5");

Copyright© 2019 HCL Technologies Limited