Informix

nested-group-icon.png

DB2

Expand all | Collapse all

Limits in Informix

  • 1.  Limits in Informix

    Posted Mon December 14, 2020 04:27 AM
    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
    ------------------------------


  • 2.  RE: Limits in Informix

    Posted Mon December 14, 2020 07:34 AM
    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
    ------------------------------



  • 3.  RE: Limits in Informix

    Posted Mon December 14, 2020 07:59 AM

    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  





  • 4.  RE: Limits in Informix

    Posted Mon December 14, 2020 08:13 AM
    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
    ------------------------------



  • 5.  RE: Limits in Informix

    Posted Mon December 14, 2020 10:38 AM
    the limits are mentionned on 2k page, but didn't find for 4k  page (or more)
    regards

    ------------------------------
    John Smith
    ------------------------------



  • 6.  RE: Limits in Informix

    Posted Mon December 14, 2020 11:12 AM
    What specific limit are you looking for John?


    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 7.  RE: Limits in Informix

    Posted Tue December 15, 2020 09:31 AM
    Especially those related to maximum values to anticipate actions :

    for example :

    - Maximum number of extents for a table
    - Maximum nomber of pages
    ....
    ....

    :)



    ------------------------------
    John Smith
    ------------------------------



  • 8.  RE: Limits in Informix

    Posted Tue December 15, 2020 10:01 AM
    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
    ------------------------------



  • 9.  RE: Limits in Informix

    Posted Mon December 14, 2020 10:11 AM
    Thanks a lot :) Art and Khaled :)

    ------------------------------
    John Smith
    ------------------------------