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------------------------------
Original Message:
Sent: Tue December 15, 2020 09:31 AM
From: John Smith
Subject: Limits in Informix
Especially those related to maximum values to anticipate actions :
for example :
- Maximum number of extents for a table
- Maximum nomber of pages
....
....
:)
------------------------------
John Smith
Original Message:
Sent: Mon December 14, 2020 11:11 AM
From: Art Kagel
Subject: Limits in Informix
What specific limit are you looking for John?
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
Original Message:
Sent: Mon December 14, 2020 10:37 AM
From: John Smith
Subject: Limits in Informix
the limits are mentionned on 2k page, but didn't find for 4k page (or more)
regards
------------------------------
John Smith
Original Message:
Sent: Mon December 14, 2020 07:58 AM
From: khaled Bentebal
Subject: Limits in Informix
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
Original Message:
Sent: 12/14/2020 4:27:00 AM
From: John Smith
Subject: Limits in Informix
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
------------------------------