drop plogspace: Drop the plogspace (SQL administration API)

Use the drop plogspace argument with the admin() or task() function to drop the plogspace.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(--"drop plogspace"--)--;------><
                     '-task--'                              

Usage

The plogspace must be empty to be dropped. For example, if you move the physical log out of the plogspace and into a dbspace by running the onparams -p command, you can drop the plogspace. Alternatively, you can move the plogspace to a different chunk by creating a new plogspace. The old plogspace is removed automatically.

This function is equivalent to the onspaces -d command.

Example

The following example drops the plogspace:

EXECUTE FUNCTION task("drop plogspace");

Copyright© 2019 HCL Technologies Limited