Re: Maximum table size ?

In article <356D8415.E49@crosskeys.com>, Mark Christmas <mchristmas@crosskeys.com> writes >Art S. Kagel wrote: >> >> Helmut Leininger wrote: >> > >> > Hi, >> > >> > Is there a limit on the table size and/or number of rows in a table in >> > Informix Online 7.xx? >> > Maybe this information is somewhere in the manuals but I did not find >> > it. >> >> It is in the release notes in: >> $INFORMIXDIR/release/en_us/0333/SERVERS_7.? >> >> A tablespace is limited to 16million pages or 2^32 rows, a table may be >> made up of up to 1000 tablespaces as fragments. Actually while the >> engine is limited to 1000 tablespaces it is also limited to 1000 disk >> chunks (which can be 4K or 2K depending on the system) so the practical >> limit is <4TB (1000 * 2^32 or 1000 * 2^31). >> >> Art S. Kagel > >Art: are you sure that the number of chunks is limited to 1000? I know >that this the Onmonitor limit, but I always thought that there was a >much higher logical limit (practical limit being much closer to the 1000 >Onmonitor limit). > Correct. Online Admin Guide, Volume 2 Version 7.1 Page 38-11 CHUNKS range of values From DBSPACES to maxChunks where maxChunks= lesser of 2048 and (maxOpen-6) where maxOpen = maximum number of open files per process allowed by the operating system. Yes, I know 7.10.UD1 made this parameter dynamic and it's no longer in onconfig but surely the 2048 limit was not reduced?? PS Some of the other limits seem silly. 8 million locks is a bit low and 21 million databases (??) thats not even a power of 2!! >Mark > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care