Informix limitations
Smith John asked where to find Informix version limits such as maximum pages and extents. Art Kagel pointed to Carlton Doe's article on edition differences and the Knowledge Center limits page. Smith found the 11.70 page, based on 2k pages, and asked whether limits differ for larger pages. Art said only data bytes per fragment grows proportionally with page size.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi to All please, where to find different informix versions limitations (nb max of pages, extents...etc ? thanks in advance
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
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 ?
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