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