}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)