Re: does 16k page limit apply to index pages ?

Ues indexes also have to fit within 16million pages. Art Art S. Kagel Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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, Sep 12, 2011 at 6:35 AM, Floyd Wellershaus <floyd@fwellers.com>wrote: > I guess the subject says most of it. > I have a script to warn us when a table is approaching that limit. > It's doing this: > oncheck -pt $DBNAME:$tab |grep "pages allocated"|awk '{print $NF}'|sort -nr > |head -1> > I am getting a high number for an Index dbspace. So I need to know if that > is also part of the limit. If it is, then I'll rebuild the index in space > with a larger pagesize. > If not, then I need to change the script to be able to tell if it's an > index dbspace or a tablespace. > > Thanks, > Floyd > > > > -- > Floyd Wellershaus > Dba/Sa Informix/Oracle/Linux/Aix > > http://photos.fwellers.com > ======================================================== > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >

Is it just me that believes that this "feature" is fast becoming a serious limitation in Informix - particualrly as it's difficult to obviate in anything other than Enterprise Edition? "Art Kagel" <art.kagel@gmail.com> wrote in message news:mailman.1123.1315826084.1071.informix-list@iiug.org... Ues indexes also have to fit within 16million pages. Art Art S. Kagel Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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.