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
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
================================================== ======

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 (AT) fwellers (DOT) 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 (AT) gmail (DOT) com> wrote:


--
Floyd Wellershaus
Dba/Sa Informix/Oracle/Linux/Aix

http://photos.fwellers.com
================================================== ======

select dbsname, tabname, nptotal, npused
from sysmaster:systabnames st, sysmaster:sysptnhdr sp
where st.partnum = sp.partnum
and nptotal >12000000;

That will flag any tables, indexes, or fragments of them as they get in
range to have a problem.

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 7:16 AM, Floyd Wellershaus <floyd (AT) fwellers (DOT) com>wrote:

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 (AT) fwellers (DOT) com>wrote:



--
Floyd Wellershaus
Dba/Sa Informix/Oracle/Linux/Aix

http://photos.fwellers.com
================================================== ======

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:

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 (AT) gmail (DOT) 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.