Extent doubling/Fragmented table

Posted in 1999

Topics: Storage & Space Management, Server Administration, Versions, Editions & End-of-Life

Jay Walters — Tue, 20 Apr 1999 21:59:49 -0400 — source: Informix-list mailing list archive (1991-1998)

In the IDS 7.30 manuals it appears to say that regardless of other settings IDS will double your next extent size after 16 extents in a single table. I am planning on a fragmented table, mostly for management of the data - ease in dropping a fragment, etc, but I expect to have more than 16 fragments. Does this extent doubling occur in fragmented tables, and if so is there a good trick to avoid this 'help' IDS is giving us DBA's with our job? Cheers

↪ replying to Jay Walters

Art S. Kagel — Wed, 21 Apr 1999 14:26:40 -0400 — source: Informix-list mailing list archive (1991-1998)

Jay Walters wrote: > > In the IDS 7.30 manuals it appears to say that regardless of other > settings IDS will double your next extent size after 16 extents in a > single table. I am planning on a fragmented table, mostly for > management of the data - ease in dropping a fragment, etc, but I expect > to have more than 16 fragments. Does this extent doubling occur in > fragmented tables, and if so is there a good trick to avoid this 'help' > IDS is giving us DBA's with our job? The doubling does happen but the 16 extents is calculated per table fragment not per table. Art S. Kagel

Glossary

IDS (Informix Dynamic Server)