Limits in Informix
John Smith asked where to find Informix limits for 11.70, 12.x and 14.x. Art Kagel and Khaled Bentebal pointed to release notes and documentation pages for each version. Art explained the per-partition limits: 2047 extents, about 2^24 data pages, 2^31-1 index pages, up to 2047 fragments per table, and 132 PB maximum server storage. Answered.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi Please where can i find Limits on Informix, first on 11.70 and also on other posterior versions 12.x 14x i only found on a 32 bits system Thanks in advance ------------------------------ John Smith ------------------------------ #Informix
Some are in the release notes under INFORMIXDIR/release. There is a limits page in the online docs. Can't search for it right now. ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------
Hi John, If your are looking for technical limits for the Informix versions, here are some links:?? 11.70: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.70.0/com.ibm.adref.doc/ids_adr_0719.htm 12.10 https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.adref.doc/ids_adr_0718.htm If your are looking for license limits, here is a link for all products (you need to select the edition and the version you want): https://www-03.ibm.com/software/sla/sladb.nsf/displaylis/1947B9B1AC94F35E852577B900760663?OpenDocument -- Cordialement, Regards, Khaled Bentebal Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web: www.consult-ix.fr
Thanks Khaled. Here is the link for v14.10: https://www.ibm.com/support/knowledgecenter/SSGU8G_14.1.0/com.ibm.adref.doc/ids_adr_0718.htm ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------
Thanks a lot :) Art and Khaled :) ------------------------------ John Smith ------------------------------
the limits are mentionned on 2k page, but didn't find for 4k page (or more) regards ------------------------------ John Smith ------------------------------
What specific limit are you looking for John? ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------
Especially those related to maximum values to anticipate actions : for example : - Maximum number of extents for a table - Maximum nomber of pages .... .... :) ------------------------------ John Smith ------------------------------
John: OK, so those are documented, but to make it simple, these values are per partition/fragment, as a table can span multiple partitions: Maximum extents: 2047 which with extent doubling and the per partition page limit (below) is virtually unlimited Maximum data pages: 2^24 minus a few for overhead (bitmap pages, etc.) 32,775,134 data pages in a data partition (32,777,215 pages total) 2^31 - 1: or 2,147,483,647 index pages per index partition Note that a table can have up to 2047 partitions/fragments, so it is possible for a table on wide pages to take up nearly all of the server's maximum storage of 132PB. It is also possible, using sharding, to distribute a very large table or tables across multiple servers meaning that there is really no limit on an Informix table. ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------