Re: Bug (?) in Online ??!!

Juha Eklund writes: >Hello netters, >I(ve seen some strange behavior when deleting rows in table.In the record >there are one reference to blob area ( xxxx BYTE in blob_xxxx ). When I >delete the record, the space for the blob should also be freed ( automa- >tically (?) or isnt it so ?? ). The row disappears, but the free space >for the blob_space chunk ISNT added ???? What I am doing wrong or is there >a bug in the Online ??? No bug, just documented behavior. Because blobspace blobs are not logged, deleted blobs must remain available on disk (for fast recovery) until the logical log containing the transaction that deletes the blob has been backed up and freed. At that time, all blobspace blobs deleted by transactions in that log will be freed. >PS2: Yes, I did a tbmode -c and tbmode -l and backed up the logical log But it as to be *freed* not just backed up. >PS3: Are there any hope that in the future you can drop a chunk ????? > Or is the only way to drop the whole dbspace/dobspace ????? 6.0 will allow you to drop any empty "additional" chunk in a dbspace (the first chunk assigned to the dbspace at dbspace create time can only be "dropped" by dropping the dbspace). Dave -- Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney