clean sbspace argument: Release unreferenced smart large objects (SQL administration API)

Use the clean sbspace argument with the admin() or task() function to release any unreferenced BLOB or CLOB objects from the sbspace.


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

>--"clean sbspace"--,--"sbspace"--)--;-------------------------><

Element Description Key Considerations
sbspace The name of the sbspace to clean.  


This function is equivalent to the onspaces -cl command.


The following example cleans an sbspace named sbsp1:
EXECUTE FUNCTION task("clean sbspace","sbsp1");

Copyright© 2018 HCL Technologies Limited