drop plogspace: Drop the plogspace (SQL administration API)

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

Syntax


1  EXECUTE FUNCTION
1 admin
1 task
2  ( "drop plogspace"
2  ) ;

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