RE: Extent size limit

Posted in 2007

Jack Parker — Tue, 12 Jun 2007 18:29:54 -0400 — source: Usenet: comp.databases.informix

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!