RE: Programmatically checking available space?
Hi David!
To check how much space you have used/left per chunk or
per dbspace you could either user onstat -d or check the
sysmaster database with something like this:
select distinct(b.name) DBSpace, sum(a.chksize) Total,
sum(a.nfree) Free,
round((sum(a.nfree) * 100 / sum(a.chksize)),2) percent
from syschunks a,
sysdbspaces b
where a.dbsnum=b.dbsnum
group by b.name
order by b.name;
select b.name DBSpace, a.chksize Chunksize,
(a.chksize - a.nfree) Used, a.nfree Free
from sysmaster:syschunks a,
sysmaster:sysdbspaces b
where a.dbsnum=b.dbsnum
order by b.name;
Hope this helps. Try to make use of the sys* tables.
Cheers.
Ralph.
*********** ralph.halter@pac.panmail.com *****************************