There's a math problem in your statement here. You have a couple (2) of
tables at 262xxx pages in a dbspace of 512,000 pages. That puts you 12,000
pages or so over the limit. I am unsure whetehr you have a chunk of space
at the end or only a few pages. When the table next needs to expand, it
should grab whatever remaining space it can - provided that that is over
16K.
j.
-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org]On Behalf Of Octavio Gomez
Sent: Tuesday, June 12, 2007 2:54 PM
To: informix-list@iiug.org
Subject: Extent size limit
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. Check it out!