Re: Determine free space in Informix 7 database
The space reported as *used* includes extents allocated but not filled.
This script reports data similar to onstat -d, but a tad more readable.
#!/bin/sh
/usr/informix/bin/onstat -b |egrep 'not initialized' >/dev/null 2>&1
if [ $? -ne 0 ]; then
$INFORMIXDIR/bin/dbaccess sysmaster << EOF 2>/dev/null |tail +3
select name,
sum(chksize)*2 k_size,
round(sum(nfree)*2) k_free,
round(sum(nfree)/sum(chksize)*100,2) pct_free
from syschunks c,sysdbspaces d
where c.dbsnum=d.dbsnum
group by name
order by name;select sum(chksize)*2 k_total,
(sum(chksize) - sum(nfree))*2 ttl_used,
sum(nfree)*2 ttl_free,
round(sum(nfree)/sum(chksize)*100,2) ttl_pct
from syschunks;
EOF
else
echo ""
echo " Informix Engine off-line!"
echo ""
fi
Bart De Groeve wrote in message <349FC5BF.1C38B7DE@bru-co.be.dhl.com>...
>Dear all,
>
>I'm having problems determining the exact amount of free space in an
>Informix Database. I don't think you can really rely on the command
>onstat -d. Is there anyone who can help me with this?>
>Thanks and best regards,
>Bart De Groeve
>DHL Belgium
>