Re: free space
Just run the following script:
--------------------------------------
dbaccess sysmaster << EOF 2>/dev/null
SELECT syschktab.dbsnum, name[1,10],
SUM(nfree)*2 FREE_IN_KB,
SUM(chksize)*2 SIZE_IN_KB,
(sum(nfree)/sum(chksize))*100 PERCENT_FREE
FROM syschktab, sysdbstab
WHERE syschktab.dbsnum=sysdbstab.dbsnum
GROUP BY syschktab.dbsnum, name
ORDER BY 5;EOF
--------------------------------------
-Bill
>
> Does anyone have any scripts written that will look at a tbstat -d or
> onstat -d , and calculate in mg how much space is available in each> dbspace?
> I get tired of counting pages and I'm having trouble with an awk script
> to do this....
>
> Tks
>
>
> --
> ----------------------------------------------------------------------------
> Ed Bidinotto bidinott@ucar.edu
>
--
Bill Ennis Voice: 312-474-7516
SSA Fax: 312-474-7460
500 W. Madison email: ennis@ssax.com