storagepool purge argument: Delete storage pool entries (SQL administration API)

Use the storagepool purge argument with the admin() or task() function to delete all storage pool entries, storage pool entries that have a status of Full, or storage pool entries that have a status of Error.


1  EXECUTE FUNCTION
1 admin
1 task
2  (
3.1 "storagepool purge all"
3.1 "storagepool purge full"
3.1 "storagepool purge errors"
3.1  ) ;

Usage

Use the storagepool purge all argument to delete all entries in the storage pool.

Use the storagepool purge full argument to delete all storage pool entries that have a status of Full.

Use the storagepool purge errors argument to delete all storage pool entries that have a status of Error.

The storagepool table in the sysadmin database contains a column that shows the status of each entry in the storage pool.

Example

The following command deletes all storage pool entries that have a status of Full:

EXECUTE FUNCTION task("storagepool purge full");