Extents
Posted in 2000
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? 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. Thanks again Robin