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