Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Colin Dawson — — source: Usenet: comp.databases.informix
The maximum extent sizer is limited to your chunk size.......maximum 2Gb
which is 1048575 2K pages or 524287 4K pages.
>From the 7.31 SQL Manual.....
"The minimum length is four times the disk page size on your system. For
example, if you have
a 2-kilobyte page system, the minimum length is 8 kilobytes. The maximum
length is equal to
the chunk size."
FYI
A 2Gb chunk is actually 1024**3 = 2097152, the size allocated to Informix
cannot be that exact value exactly and must be a multiple of the page size
so when using onspaces the -s option can only be 2097150 for a 2K page or
2097148 for a 4K page, hence the value stated above.
Hope this helps
Regards
Colin
There are 10 types of people in the world, those that understand binary and
those that don't
>From: mchivaviro@okzim.co.zw
>To: informix-list@iiug.org
>Subject: Maximum Extent size
>Date: 13 Sep 2006 03:10:44 -0700
>
>I am using IDS 7.31 and I have a big table which is now 22gigs in size.
>It now has 60 extents and I need to unload and recreate the table
>again. What is the maximum extent size I can create and the next size
>of the extent.
>
>_______________________________________________
>Informix-list mailing list
>Informix-list@iiug.org
>http://www.iiug.org/mailman/listinfo/informix-list
_________________________________________________________________
Windows Live' Messenger has arrived. Click here to download it for free!
http://imagine-msn.com/messenger/launch80/?locale=en-gb
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.