storagepool delete argument: Delete one storage pool entry (SQL administration API)

Use the storagepool delete argument with the admin() or task() function to delete an entry from the storage pool.

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

>--"--storagepool delete--"--,--"--entry_id--"--)--;-----------><

Element Description Key Considerations
entry_id The ID of the storage pool entry. The storagepool table in the sysadmin database contains a column that shows the ID of each entry in the storage pool.

Usage

Delete a storage pool entry if you do not want the server to continue to use the entry when expanding a storage space.

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, use the SQL administration API storagepool purge command. (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 the storage pool entry with an entry id of 13:

EXECUTE FUNCTION task("storagepool delete", "13");

Copyright© 2018 HCL Technologies Limited