Delete smart large objects without any pointers

Each smart large object has a reference count, the number of pointers to the smart large object. When the reference count is greater than 0, the database server assumes that the smart large object is in use and does not delete it.

Rarely, a smart large object with a reference count of 0 remains. You can use the onspaces -cl command to delete all smart large objects that have a reference count of 0, if it is not open by any application.

For information about using onspaces -cl, see information about the onspaces utility in the HCL Informix® Administrator's Reference.


Copyright© 2019 HCL Technologies Limited