RE: Extents

> 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? Any extent must be a multiple of the page size. So setting the first extent to the page size would be setting it to the minimum that it can be. I find it very suspicious that informix would recommend a value of 24. I am hoping that there is maybe some other information/circumstances that you have not mentioned. If it was me I would do dbaccess $dbname q -- for query language i -- info type in the table name s -- for status This should show you the row size for the table. To get a rough idea of the size of the whole table compute num_rows * row_size This will give you a value which you should be able to use for your first extent size. ( you'll have to work out the value in kb so that you can use it with the extents clause ) I have numerous tables with first extents around the 5120 mark and my larger tables can have first extents around the 40 Mb mark. I can also tell you that the databases that I deal with are tiny and it is not uncommon to hear of first extents around the 2Gb mark. > > 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 > > > > > ___________________________________________________________________________ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Sema Group. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the Sema Group Helpdesk by telephone on +44 (0) 121 627 5600. ___________________________________________________________________________