alter table: 'lost' extents
Posted in 2004
Alexey Sonkin — — source: Usenet: comp.databases.informix
Hi, everybody,
I've just found a very unpleasant problem with 9.21uc4
I have a huge table that was altered (column added) when it was big enough.
'Alter table' was 'in-place' - just because the operation went very fast.
After that, a lot of inserts were made, and old records were not updated.
Later, the table was dropped.
When I made an analysis of disk extents with 'oncheck -pe', I was surprised:
a lot of extents (actually, containing all the 'before alter table' records)
were not released by the 'drop table'!!!
Is it a known bug?
Is it fixed in 9.40?
Is there way to return extents to the free page pool?
------------------------------------------
Alexey Sonkin
sending to informix-list