Re: Extents

From: Boscia <rwboscia@worldnet.att.net> > >Hi it's me again.... with a different question.... > >I've read the posts on extents but I don't feel this question has been >answered... > >I have one table that is 70,000,000 records & we feel will grow to >90,000,000 >It is in it's own dbspace and has additional chunks allocated to it. > >I had a problem with it yesterday (Error 136) and had to unload, drop, >rebuild, & reload. I called Informix and they suggested I set the first >extent at 24 and next extent at 24. I'm not real comfortable with that. >Being as this is the only table in the dbspace, should I make the first >extent the size of the page? And next extent what? EXTENTSIZE 1 isn't even allowed. 24 seems low, to put it unusually mildly. 24000 seems more reasonable. >Also, one of the posts referenced a download from the iiug site from Art >myschema (utils_3 ? Sounds like something I could use, but went to the >iiug site and can't seem to find it. Could you give me more specifics on >how >to find it on the site. http://www.iiug.org/software ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com