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

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

Syntax

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

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

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

Example

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

EXECUTE FUNCTION task("drop blobspace to storagepool", "blob2");

Copyright© 2019 HCL Technologies Limited