does 16k page limit apply to index pages ?
Posted in 2011
Floyd Wellershaus — — source: Usenet: comp.databases.informix
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
========================================================