SEO

#1 (**permalink**) 04-19-2008, 06:30 PM

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

#2 (**permalink**) 04-19-2008, 06:30 PM

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
>
>

#3 (**permalink**) 04-19-2008, 06:30 PM

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
> >
> >
>
>

#4 (**permalink**) 04-19-2008, 06:30 PM

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
> > >
> > >
> >
> >
>
>

#5 (**permalink**) 04-19-2008, 06:30 PM

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
>:|

#6 (**permalink**) 04-19-2008, 06:40 PM

Valium wrote:
> 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
>
Y yo tampoco hablo bien el Espanol. Onstat -d no le dara un valor para
el espacio que es disponible despues de hacer DELETE. En el espacio de
las tablas, las entradas no validas seran re-usadas. Pero Infomix no
libera ningunas paginas asignadas nunca, a menos que haga un DROP de las
tablas u indices.

Asi que onstat -d le dara un idea imprecisa del espacio disponible;
podria usar oncheck -pe para mejor informacion, pero tampoco es preciso.

Espero que me explique algo.

Bob

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Space Usage on Informix Question