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

Thanks Art and Obnoxio. You don't happen to know of a good sql to determine this. I am not good enough with Awk to be able to tell from the oncheck output in a script. On Mon, Sep 12, 2011 at 7:14 AM, Art Kagel <art.kagel@gmail.com> wrote: > 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 >> >> > -- Floyd Wellershaus Dba/Sa Informix/Oracle/Linux/Aix http://photos.fwellers.com ========================================================