How can I feeing space in a Informix Database
MikeHeide deleted many rows but saw no space freed. Obnoxio suggested unload/reload, ALTER FRAGMENT or ALTER INDEX TO CLUSTER. Mark Scranton said extents once allocated are not freed automatically and that freeing unused space was being considered for future IDS releases. Malcolm Weallans added that deleted space is reused, so chunks will not run out.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
I have deleted many rows in on table, but it seems that this has no effect on the total used space by the database. So it will be in a short time that the database is running out of free chunks in a short time. Who can help?
MikeHeide said: > I have deleted many rows in on table, but it seems that this has no > effect on the total used space by the database. So it will be in a > short time that the database is running out of free chunks in a short > time. > Who can help? Unload / reload, ALTER FRAGMENT, ALTER INDEX TO CLUSTER ... RTFM? -- Bye now, Obnoxio "Jesus you fucking people are hopeless." -- Double Anal
Obnoxio The Clown wrote: > MikeHeide said: > > I have deleted many rows in on table, but it seems that this has no > > effect on the total used space by the database. So it will be in a > > short time that the database is running out of free chunks in a short > > time. > > Who can help? > > Unload / reload, ALTER FRAGMENT, ALTER INDEX TO CLUSTER ... RTFM? > > -- > Bye now, > Obnoxio > > "Jesus you fucking people are hopeless." > -- Double Anal Once extents (from a chunk) have been allocated to a structure (tablespace/table/fragment/partition/index/etc.), they are not freed automatically, even if empty. We are considering the freeing of "unused space" like this in future releases of IDS. OTC's recommendations are correct... Thanks - Mark.
Despite the advice given by Obnoxio and Mark Scranton the situation is not as bad as you think. The system will re-use the deleted space. So you won't run out of chunks. You might notice a small performance degradation if the data is normally accessed sequentially but most systems don't. The real answer with all sysadmin issues is "Don't Panic". Regards Malcolm -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of MikeHeide Sent: 25 February 2006 23:18 To: informix-list@iiug.org Subject: How can I feeing space in a Informix Database I have deleted many rows in on table, but it seems that this has no effect on the total used space by the database. So it will be in a short time that the database is running out of free chunks in a short time. Who can help? _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list
mark.scranton@gmail.com wrote: > Obnoxio The Clown wrote: >> MikeHeide said: >>> I have deleted many rows in on table, but it seems that this has no >>> effect on the total used space by the database. So it will be in a >>> short time that the database is running out of free chunks in a short >>> time. >>> Who can help? >> Unload / reload, ALTER FRAGMENT, ALTER INDEX TO CLUSTER ... RTFM? >> >> -- >> Bye now, >> Obnoxio >> >> "Jesus you fucking people are hopeless." >> -- Double Anal > > Once extents (from a chunk) have been allocated to a structure > (tablespace/table/fragment/partition/index/etc.), they are not freed > automatically, even if empty. We are considering the freeing of > "unused space" like this in future releases of IDS. > > OTC's recommendations are correct... > > Thanks - > Mark. > Are you suggesting a "shrink database" functionality like found in MS-SQL-Server?