Hi
on 11.70.FC8 (i know i have to upgrade , it s ongoing :) )
i calculated the space free with onstat -d and the statement below, but the output are different
with onstat -d (free column * page size), each dbspace has different pagesize
and on sysmaster
database sysmaster;
select name[1,8] dbspace, -- name truncated to fit on one line
round(sum(chksize * d.pagesize), 2) Total_size, -- sum of all chuncks size pages
round(sum(nfree * d.pagesize),2) Space_Free,
round (100 - (sum(nfree)) / (sum(chksize)) * 100, 2) percent_Used
from sysdbspaces d, syschunks c
where d.dbsnum = c.dbsnum
and d.is_blobspace = 0
and d.is_sbspace = 0
group by 1;
does anyone faced it before ?
Thanks :)
------------------------------
John Smith
------------------------------
#Informix