Re: Informix database reorganization

Jonathan Knight wrote: > > Does moving a table from one dbsapce to another also defragment the table - > reducing the number of extents used? Could you use it as a mechanism to > reduce the fragmentation of a database? That's exactly what we are talking about here and the ALTER FRAGMENT... INIT ... statement can name the same dbspace that the table already resides in to boot. > Jon > > > > > Joe Lumbley <jlumbley@netcom.com> wrote: > > : There's one very troubling point about your situation. You are > > demanding > > : 100% uptime and your development is "still in progress". Surely you > > have > > : separate development and production environments on different machines? > > > > : If not, you'll be like a dog chasing its tail. > > > > : Good luck.....btw the alter fragment is a good approach. > > > > Can ALTER FRAGMENT...INIT IN dbspace be done within the same dbspace? Yes it can. It will work so long as the freespace in the dbspace is not too fragmentary and repeated reorgs will resolve that problem, too. > > Does this work forever or at some point do you have to do a total re-org? Yes it works forever. Art S. Kagel