View Single Post

   
  #1 (permalink)  
Old 04-19-2008, 06:30 PM
Jack A
 
Posts: n/a
Default Space Usage on Informix Question

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


Reply With Quote