Re: Disappearing BLOB space

}From: Dave Snyder <uunet!snide.com!dave.snyder> }Subject: Disappearing BLOB space }Date: Wed, 24 Mar 1993 18:46:27 -0500 (EST) }X-Informix-List-Id: <list.2047> } We have a rootdbs and also a blob-space (for TEXT blobs) } When we delete a row from the table which has a blob, why isn't that } deletion reflected in the free-page count for the blob-space? } Also, if we right-of-way add a new row to the table and include a blob, } the free-page count immediately reflects the addition of the blob. }At first I thought that this was something similar to the way deleted rows }in Informix-SE don't reduce the size of the data file. But when you add }a new row in SE, the size of the data file doesn't grow until you fill up }all the holes left by deleted rows. This doesn't seem to be the case in }ONLINE's blob-space. Any ideas? Have you backed up the logical logs between the time when you released the data and the time when you check on the free space. If you read the small print on blob handling, you will find that the blob space is not available for re-use until the blob cannot be required for recovery, because OnLine does not put blob data from blob spaces into the logical log. Page 2-141 of the 5.00 OnLine Admins Guide is relevant. Yours, Jonathan Leffler (johnl@obelix)