Re: Freeing up sbspace

On 25 Jan, 22:27, "Laurie Gustin" <lgus...@utah.gov> wrote: > IDS 11.5 FC5 > Linux x86 > > I deleted a table that stored images in an sbspace that should have freed up approximately 1/2 of the space. > It didn't seem to free up any space.  Is there something special that needs to be done to free up the space for re-use?  I had to add another chunk to the space, and it is being used up, but it doesn't appear that dropping the old table did any good.. > > Any insight is appreciated. > > Thanks > Laurie > > Laurie Gustin > IT Programmer Analyst > Department of Public Safety > lgus...@utah.gov > 801-965-4410 http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.adref.doc/adref376.htm Dropping the old table should free space, run onspaces -cl sbspace - Cleans up stray smart large objects in an sbspace "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." Then use oncheck -cS to check what is using the sbspace.