Re: script for dbspace usage
Tony,
How about this select for the sysmaster database:
select trim(fname),
chknum,
dbsnum,
chksize,
chksize-nfree usedpages,
nfree
from syschktab
If you want it more formatted you could write an Ace or 4gl report.
Regards,
Steve Berg - spb@masada.nb.com
On Sun, 9 Jun 1996, Tony Reynolds (Acc & Purchasing Helpdesk) wrote:
> Has any one got a script to
> enable me to see pages free, %age used of
> dbspaces for online 7.
> I have a script but it disregards dbspaces with
> multiple chunks.
> The script I've got uses awk on the output of
> onstat -d and I dont know> enough about awk to modify it.
> Can anyone help??
> Tony Reynolds :-))
> tr-3475@necadmin.necvenues.co.uk
> The National Exhibition Centre Ltd
>