Returning empty space to the storage pool
You can return the space from an empty chunk or storage space to the storage pool.
About this task
To return storage space from an empty chunk, dbspace, temporary dbspace, blobspace, sbspace, or temporary sbspace to the storage pool:
Procedure
Run the admin() or task() function with one of the
following arguments for returning space to the storage pool. The elements
you use in the command vary, depending on the type of object that
you are dropping.
EXECUTE FUNCTION task("drop chunk to storagepool", "space_name", "chunk_path", "chunk_offset")EXECUTE FUNCTION task("drop dbspace to storagepool", "space_name");EXECUTE FUNCTION task("drop tempdbspace to storagepool", "space_name");EXECUTE FUNCTION task("drop blobspace to storagepool", "space_name");EXECUTE FUNCTION task("drop sbspace to storagepool", "space_name");EXECUTE FUNCTION task("drop tempsbspace to storagepool", "space_name");
Examples
The
following command drops an empty blobspace named blob4 and
adds all of the freed space to the storage pool.
EXECUTE FUNCTION task("drop blobspace to storagepool", "blob4");The
following command drops an empty chunk in a dbspace named health and
adds all of the freed space to the storage pool.
EXECUTE FUNCTION task("drop chunk to storagepool", "health",
"/health/rawdisk23", "100 KB");