How can I feeing space in a Informix Database

Posted in 2006

MikeHeide — 25 Feb 2006 15:18:14 -0800 — source: Usenet: comp.databases.informix

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?

↪ replying to MikeHeide

Obnoxio The Clown — Sun, 26 Feb 2006 00:56:46 -0000 (GMT) — source: Usenet: comp.databases.informix

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

↪ replying to Obnoxio The Clown

mark.scranton@gmail.com — 25 Feb 2006 17:09:27 -0800 — source: Usenet: comp.databases.informix

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.

↪ replying to MikeHeide

malcolm weallans — Sun, 26 Feb 2006 10:17:05 -0000 — source: Usenet: comp.databases.informix

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

↪ replying to mark.scranton@gmail.com

Double Echo — Tue, 28 Feb 2006 14:41:25 -0500 — source: Usenet: comp.databases.informix

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?