How can I feeing space in a Informix Database
This is a discussion on How can I feeing space in a Informix Database within the Informix forums, part of the Database Server Software category; --> I have deleted many rows in on table, but it seems that this has no effect on the total ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 11:39 AM
| ||||
| ||||
 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?      |
|
04-20-2008, 11:39 AM
| |||
| |||
| Re: How can I feeing space in a Informix Database 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 |
|
04-20-2008, 11:39 AM
| |||
| |||
| Re: How can I feeing space in a Informix Database 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. |
|
04-20-2008, 11:39 AM
| ||||
| ||||
| Re: How can I feeing space in a Informix Database 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? |
Linear Mode
