Clean Up Stray Smart Large Objects in Sbspaces

Home | Previous Page | Next Page Administrative Utilities > Managing Storage Spaces with the onspaces Utility >

Clean Up Stray Smart Large Objects in Sbspaces

Clean Up Stray Smart Large Objects in Sbspaces:
 
|-- -cl--sbspace------------------------------------------------|

Element	Purpose	Key Considerations
-cl	Cleans up stray smart large objects in an sbspace	To find any stray smart large objects, use the oncheck -pS command when no users are connected to the database server. The smart large objects with a reference count of 0 are stray objects.
sbspace	Names the sbspace to be cleaned up	References: Syntax must conform to the Identifier segment; see the IBM Informix Guide to SQL: Syntax.

During normal operation, no unreferenced (stray) smart large objects should exist. When you delete a smart large object, the space is released. If the database server fails or runs out of system memory while you are deleting a smart large object, the smart large object might remain as a stray object.

The following is an example of the onspaces -cl command:

onspaces -cl myspace

The best way to find the reference count for a smart large object is to call the mi_lo_stat or ifx_lo_stat functions from a C program. Although the mi_lo_increfcount and mi_lo_decrefcount functions return the reference count, they increment or decrement the reference count. For more information on these functions, see the IBM Informix DataBlade API Function Reference.