$ oncheck -pe

를 사용하세요....

아님.

아래 shell script를 informix로 수해하시고요..

============================================================

tabinfo2.sh

사용법 : tabinfo2.sh <db name>

#
#
#    tabinfo.sh
#
#
if [ ! "$1" ]
then
   echo
   echo "USAGE: $0 <database> [<table>]"
   echo
   exit 2
fi

database_name=$1

t_sort="TABLE NAME"

dbaccess $database_name 2> /dev/null << +
set isolation to dirty read;
unload to tabinfo2.out delimiter " "
select  a.tabname,
        c.rowsize,
        c.locklevel,
        c.ncols,
        c.nrows,
        c.nindexes,
        c.fextsize,
        c.nextsize,
        count(*),
        sum(b.pe_size),
        trunc(a.partnum/1048576)
from sysmaster:systabnames a, sysmaster:sysptnext b, systables c
where c.tabid > 99
and c.tabtype = "T"
and a.partnum = b.pe_partnum
and a.tabname=c.tabname
group by 1,2,3,4,5,6,7,8,11
order by 1
+
echo "Table info for database "$database_name"                   Sorted on : "$t_sort
echo "===================================================================================="
echo "     TABLE               Dbs#  ROW LCK #COLS  #ROWS #IDX   FEXT  NEXT  TOTAL  TOTAL"
echo "                               SIZ LVL                     (Kb)  (Kb)  #EXTS SIZ(Kb)"
echo "------------------------------------------------------------------------------------"
cat tabinfo2.out | awk '{ { printf( "%-25s %2d  %4d  %1s %3d %8d  %2d  %6d %6d %3d  %8d\n", \
                                    $1,$11,$2,$3 ,$4,$5,$6,$7,$8,$9,$10*2) } }'
#$10*2 => 2 is page size in kb
#$10*4 => 4 is page size in kb
echo "===================================================================================="

rm tabinfo2.out