원본출처 : 딧세님홈페이지 (http://informix.we.ro/)

#

#

# dbschk.sh

#

#

dbaccess sysmaster 2> /dev/null <<+

set isolation to dirty read;

unload to dbschk.out delimiter " "

select a.name,

count(*),

sum(b.chksize),

sum(b.nfree)

from sysdbspaces a, syschunks b

where a.dbsnum = b.dbsnum

group by 1

order by 1;

+

echo "DBspace status report"

echo "======================================================="

echo "DBSPACE #CHUNKS SIZE(KB) FREE(KB) %USED"

echo "-------------------------------------------------------"

cat dbschk.out | awk '{ printf("%-20s %2d %10d %10d %2d\%\n",$1,$2,$3*2,$4*2, ($3-$4)/$3*100) }'

echo "======================================================="

rm dbschk.out