RE: Expansion of round-robin fragmentation

I can answer my own question: It' a matter of seconds. I could do a test with nearly productional environment. But that implies the next question: Will the existing nearly full fragments fill up regardless of the new fragments or will they freeze until the new fragments have reached the same fill level as the old ones? TIA, Reinhard. > -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org]On Behalf Of Habichtsberg, > Reinhard > Sent: Thursday, August 21, 2008 10:14 AM > To: Informix-List (E-Mail) > Subject: Expansion of round-robin fragmentation > > > Hi all, > > we have to change the fragmentation strategy of a fragmented > table. The > present strategy is round-robin with 5 fragments. Because the limit of > 16777216 pages per fragment of the table in question will be > reached soon we > consider to change the round-robin strategy to e.g. 10 fragments. > > >From the syntax guide: > To add another dbspace, use the ADD clause, as in this example: > ALTER FRAGMENT ON TABLE book ADD dbsp3;> > Has anybody expierence with it? Is the change a matter of > seconds or of > hours? > > IDS 9.40FC9W2 > > TIA, Reinhard > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >