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

Copyright© 2019 HCL Technologies Limited