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.

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+---------------------------------->
                     '-task--'   

>--(--+-"storagepool purge all"----+---------------------------><
      +-"storagepool purge full"---+   
      +-"storagepool purge errors"-+   
      '-)--;-----------------------'   

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

Copyright© 2019 HCL Technologies Limited