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

Posted in 2011

Floyd Wellershaus — Mon, 12 Sep 2011 07:24:43 -0400 — source: Usenet: comp.databases.informix

Ooops. Never mind. I don't have to change the script, since the Index Page is a valid warning too. ( what a dope ). Thanks again ! On Mon, Sep 12, 2011 at 7:16 AM, Floyd Wellershaus <floyd@fwellers.com>wrote: > 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 > ======================================================== > -- Floyd Wellershaus Dba/Sa Informix/Oracle/Linux/Aix http://photos.fwellers.com ========================================================