Space Usage on Informix Question

[Jack A]

Whats the best way to make sure you dont run out of space on your machines ?
I've set up some purge scripts which will purge a lot of old data on our
system. That will free up space in the data dbspace and its corresponding
chunk. But I see that the index dbspace and its chunk are very close to
getting full. Is the only way to manage this to add an extra chunk ? Will
purging data and running update stats medium shrink the indexes too ?

TIA

[Jay Aymond]

The only way to reduce the space used by the indexes is to drop and recreate
them. Running update statistics will not change the size of your tables or
your indexes.


"Jack A" <jacka8@excite.com> wrote in message
news:1532eb7213031d5a2d8c8a866f3b1d15@news.teranew s.com...

> Whats the best way to make sure you dont run out of space on your machines

?

> I've set up some purge scripts which will purge a lot of old data on our
> system. That will free up space in the data dbspace and its corresponding
> chunk. But I see that the index dbspace and its chunk are very close to
> getting full. Is the only way to manage this to add an extra chunk ? Will
> purging data and running update stats medium shrink the indexes too ?
>
> TIA
>
>

[Jack A]

Not even after purging the data ? Shouldnt a lower density of data result in
a sparser index ?

"Jay Aymond" <jaymond@communitycoffee.com> wrote in message
news:BbWcnaTYYtKu59uiXTWJkw@eatel.net...

> The only way to reduce the space used by the indexes is to drop and

recreate

> them. Running update statistics will not change the size of your tables

or

> your indexes.
>
>
> "Jack A" <jacka8@excite.com> wrote in message
> news:1532eb7213031d5a2d8c8a866f3b1d15@news.teranew s.com...

> > Whats the best way to make sure you dont run out of space on your

machines

> ?

> > I've set up some purge scripts which will purge a lot of old data on our
> > system. That will free up space in the data dbspace and its

corresponding

> > chunk. But I see that the index dbspace and its chunk are very close to
> > getting full. Is the only way to manage this to add an extra chunk ?

Will

> > purging data and running update stats medium shrink the indexes too ?
> >
> > TIA
> >
> >

>
>

[Jay Aymond]

There will be less data in the index tablespace, but the physical size of
the tablespace holding the index will not shrink.


"Jack A" <jacka8@excite.com> wrote in message
news:f42231c99c1f73e617d3a78b080c21da@news.teranew s.com...

> Not even after purging the data ? Shouldnt a lower density of data result

in

> a sparser index ?
>
> "Jay Aymond" <jaymond@communitycoffee.com> wrote in message
> news:BbWcnaTYYtKu59uiXTWJkw@eatel.net...

> > The only way to reduce the space used by the indexes is to drop and

> recreate

> > them. Running update statistics will not change the size of your tables

> or

> > your indexes.
> >
> >
> > "Jack A" <jacka8@excite.com> wrote in message
> > news:1532eb7213031d5a2d8c8a866f3b1d15@news.teranew s.com...

> > > Whats the best way to make sure you dont run out of space on your

> machines

> > ?

> > > I've set up some purge scripts which will purge a lot of old data on

our

> > > system. That will free up space in the data dbspace and its

> corresponding

> > > chunk. But I see that the index dbspace and its chunk are very close

to

> > > getting full. Is the only way to manage this to add an extra chunk ?

> Will

> > > purging data and running update stats medium shrink the indexes too ?
> > >
> > > TIA
> > >
> > >

> >
> >

>
>

[Valium]

No entiendo bien el ingles pero si lo que quieres es saber cuanto
espacio te queda en los chunks pues lo puedes ver con onstat -d y si
lo que quieres es que te ocupe menos espacio en el chunk porque has
hecho drop por ejemplo en el archivo de huellas prueba a hacer un
dbexport y seguidamente un dbimport

On Fri, 22 Aug 2003 19:42:32 GMT, "Jack A" <jacka8@excite.com> wrote:

>:|Whats the best way to make sure you dont run out of space on your machines ?
>:|I've set up some purge scripts which will purge a lot of old data on our
>:|system. That will free up space in the data dbspace and its corresponding
>:|chunk. But I see that the index dbspace and its chunk are very close to
>:|getting full. Is the only way to manage this to add an extra chunk ? Will
>:|purging data and running update stats medium shrink the indexes too ?
>:|
>:|TIA
>:|