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.

Syntax

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

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

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

Usage

This function is equivalent to the onspaces -cl command.

Example

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

Copyright© 2018 HCL Technologies Limited