RE: Maximum Extent size

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