Re: INTIAL SIZE of the sys tables

>How can I set the INITIAL extent size of the sys tables like the >informix.systable >table? > >The only thing I do now is setting the NEXT SIZE after creation of >the database. > >The reason is that I know the will be big. for example I want to set >the INTIAL SIZE to 1024 for the informix.systables. Setting the Next size immediatly after the creation of the database is about the best that you can do. If you are on anything since 7.11, I wouldn't worry too much about the "less than 8 extent" rule. In version 5, we used an extent table in memory for each tablespace which was only 8 entries large. For any extent past the eighth, we had to examine the systables table for that database directly. This is why we made such a big deal about the "eight extents". With 7.11+, we dynamically allocate memory so that all of the extents are in memory. Thus the "less than extents" rule is not nearly so important. However, if you are really going to have this many tables on a 7.1x or 7.2x system, you might want to increase your in memory dictionary somewhat. This is managed by the DD_HASHSIZE and DD_HASHMAX onconfig variables. These are undocumented so you will need to contact tech support to get information on how to use them. Madison Pruet