Informix limitations

Posted in 2016

SMITH JOHN — Sun, 17 Jul 2016 11:46:15 — source: IIUG Forums & Mailing Lists

Hi to All please, where to find different informix versions limitations (nb max of pages, extents...etc ? thanks in advance

↪ replying to SMITH JOHN

Art Kagel — Sun, 17 Jul 2016 15:59:27 — source: IIUG Forums & Mailing Lists

This link discusses the feature and resource limit differences between the various Informix "Editions". It is officially "unofficial" but it is maintained by Carlton Doe, one of the founders of the IIUG and currently an IBM evangelist for Informix: http://www.ibm.com/developerworks/db2/library/techarticle/dm-0801doe/ If you want to know about internal limitations like maximum pages per partition, numbers of chunks and dbspaces, etc., look in the Informix Knowledge Center at this link: http://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.adref.doc/ids_a dr_0718.htm Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sun, Jul 17, 2016 at 7:46 AM, SMITH JOHN <srafik0358@gmail.com> wrote: > Hi to All > please, where to find different informix versions limitations (nb max of > pages, extents...etc ? > thanks in advance > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113f64b87e0d4f0537d6eff6

↪ replying to Art Kagel

SMITH JOHN — Mon, 18 Jul 2016 10:49:34 — source: IIUG Forums & Mailing Lists

Thanks Art in fact i was looking for the 11.70 limitations, and i found this official link https://www.ibm.com/support/knowledgecenter/SSGU8G_11.70.0/com.ibm.adref.do c/ids_adr_0721.htm but it's based on a 2k page, do a limitation differ with 4k, 8k, 16k page ?

↪ replying to SMITH JOHN

Art Kagel — Mon, 18 Jul 2016 11:31:10 — source: IIUG Forums & Mailing Lists

The only thing that's really different on larger pages is the Data bytes per fragment which increases proportionally. That is documented on the v12.10 limits page link that I sent. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Jul 18, 2016 at 6:49 AM, SMITH JOHN <srafik0358@gmail.com> wrote: > Thanks Art > > in fact i was looking for the 11.70 limitations, and i found this official > link > > https://www.ibm.com/support/knowledgecenter/SSGU8G_11.70.0/com.ibm.adref.doc/ids _adr_0721.htm > > but it's based on a 2k page, do a limitation differ with 4k, 8k, 16k page ? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1143e546deadd60537e74d53