RE: Informix database reorganization

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? Jon > -----Original Message----- > From: -=Eclypse=- [SMTP:eclypse@cdc.net] > Sent: 01 October 1998 04:24 > To: informix-list@iiug.org > Subject: Re: Informix database reorganization > > 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? > > Does this work forever or at some point do you have to do a total re-org? > > [SNIP]