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

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

Syntax


>>-EXECUTE FUNCTION--+-admin-+--(------------------------------->
                     '-task--'      

>--"--drop chunk to storagepool--"------------------------------>

>--,--"space_name"--,--"path_name"--,--"offset"--)--;----------><

Element	Description	Key Considerations
space_name	The name of the storage space in which the chunk resides.
path_name	The path of the chunk.
offset	The offset, in kilobytes, of the chunk.

Example

The following command drops an empty chunk in a dbspace named bigdbs and adds all of the freed space to the storage pool.

EXECUTE FUNCTION task("drop chunk to storagepool", "bigdbs", "/dev/rawdisk23",
 "100 KB");