Oninit cdi / Archive
Talk to an expert →

Extent size limit

Posted in 2007

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

Octavio Gomez — — source: Usenet: comp.databases.informix

Hi, I'm using IDS 9.3 on Windows and I have a couple of tables with 262,144 pages of size in the last extents. The chunk size is 512,000 pages. Will the engine try to increase the extent size again or will be this the last increment? Thanks in advance! Octavio Gomez _________________________________________________________________ Live Earth is coming.  Learn more about the hottest summer event - only on MSN. http://liveearth.msn.com?source=msntaglineliveearthwlm

↪ replying to Octavio Gomez
Art S. Kagel — — source: Usenet: comp.databases.informix

On Jun 12, 2:54 pm, Octavio Gomez <sogo...@hotmail.com> wrote: > Hi, > > I'm using IDS 9.3 on Windows and I have a couple of tables with 262,144 pages of size in the last extents. > The chunk size is 512,000 pages. > > Will the engine try to increase the extent size again or will be this the last increment? The engine will double the NEXT SIZE again to 524,288 pages, but the largest actual extent can't exceed the largest chunk in the dbspace and neither can it exceed the largest free extent available at allocation time. Art S. Kagel

Glossary