Drop a storage space with onspaces

To drop a storage space with onspaces, use the -d option as illustrated in the following examples.

This example drops a dbspace called dbspce5 and its mirrors.
onspaces -d dbspce5
This example drops a dbspace called blobsp3 and its mirrors.
onspaces -d blobsp3
Use the -d option with the -f option if you want to drop an sbspace that contains data. If you omit the -f option, you cannot drop an sbspace that contains data. This example drops an sbspace called sbspc4 and its mirrors.
onspaces -d sbspc4 -f
Warning: If you use the -f option, the tables in the database server might have dead pointers to the deleted smart large objects.

For information about dropping a storage space with onspaces, see information about the onspaces utility in the HCL OneDB™ Administrator's Reference.