Re: FRAGMENTATION QUESTION (Tables with more than 16 MM pages)

Jonathan Espejo wrote: > In reference with Informix Tech Notes 1998, Volume 8, Issue 3 (Tuning > Informix Dynamic Server by Art S.Kagel) regarding tables with more than 16 > MM pages in size. As what Art said on his article that there is a limitation > of 16 Million pages per table space. What are the issues that users might > encounter of having tables with more than 16MM pages in size that are not > fragmented. The issues you *should* encounter are that you simply will not be able to add any more rows to your table when it hits 16,777,215 pages. I've never tested this, and I don't have the disk space to test it, so I can't tell you for sure that it *will* fail this way, but if it doesn't, it's bound to corrupt something. It simply cannot reference any more pages than that unless you fragment it. June -- june_t@hotmail.com Grounded in Palo Alto, living on those tube-shaped cookies, whatever they're called...