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

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(--"drop tempdbspace"----------->
                     '-task--'                          

>--,--"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");

Copyright© 2019 HCL Technologies Limited