Returning empty space to the storage pool
You can return the space from an empty chunk or storage space to the storage pool.
To return storage space from an empty chunk, dbspace, temporary dbspace, blobspace, sbspace, or temporary sbspace to the storage pool:
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");