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

Might I suggest select dbsname, tabname, nptotal from sysptnhdr a, systabnames b where a.partnum=b.partnum Easier than awking. You would of course want to match "tabname" up with idxname from you database. select dbsname, tabname, nptotal from sysmaster:sysptnhdr a, sysmaster:systabnames b where a.partnum=b.partnum and b.tabname in (select idxname from sysindexes) j. On Sep 12, 2011, at 7:16 AM, Floyd Wellershaus 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 > ======================================================== > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list