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