drop sbspace to storagepool argument: Return space from an empty sbspace to the storage pool (SQL administration API)
Use the drop sbspace to storagepool argument with the admin() or task() function to return the space from an empty sbspace to the storage pool.
Syntax
EXECUTE FUNCTION
{
admin
| task
}
(
,"drop sbspace to storagepool
"
"sbspace"
);
| Element | Description | Key Considerations |
|---|---|---|
| sbspace | The name of the empty sbspace. |
Example
The following command drops an empty
sbspace named sbspace8 and adds all of the freed
space to the storage pool.
EXECUTE FUNCTION task("drop sbspace to storagepool", "sbspace8");