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.


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

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


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.  


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");

Copyright© 2020 HCL Technologies Limited