Oninit cdi / Archive
Talk to an expert →

Maximum Extent size

Posted in 2006

Topics: Storage & Space Management, Migration, Import/Export & Data Conversion, Versions, Editions & End-of-Life

mchivaviro@okzim.co.zw — — source: Usenet: comp.databases.informix

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.

↪ replying to mchivaviro@okzim.co.zw
Keith Simmons — — source: Usenet: comp.databases.informix

In IDS 7.31 the max size is 2Gb for both first and next extent. (This is max chunk size as well). Why do you feel the need to unload and recreate? 60 extents is not that big for the size of table. If you do go this path, have you considered detaching indexes (not if you have UD4 !!) or fragmenting the table? Keith On 13 Sep 2006 03:10:44 -0700, mchivaviro@okzim.co.zw <mchivaviro@okzim.co.zw> wrote: > 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 >

Related threads

Glossary