drop tempdbspace argument: Drop a temporary dbspace (SQL administration API)
Use the drop tempdbspace argument with the admin() or task() function to drop the specified temporary dbspace.
Syntax
EXECUTE FUNCTION
{
admin
| task
}
("drop tempdbspace"
,
"tempdbspace"
);
| Element | Description | Key Considerations |
|---|---|---|
| tempdbspace | The name of the temporary dbspace to drop. | The temporary dbspace must exist. Before you drop a temporary dbspace, drop all databases and tables that you previously created in the temporary dbspace. |
Usage
This function is equivalent to the onspaces -d command.
Example
The following example drops the temporary dbspace named tdbspace2:
EXECUTE FUNCTION task("drop tempdbspace","tdbspace2");