Hi

I would like to have help in forming qurey to find % of free blob chunk in XPS machines, (i know in IDS its related to pagesize buts hows it in XPS?)

does Qurey below hold good?

SELECT name, round(sum(chksize),0), round(sum(chksize),0) - sum(nfree), sum(nfree), round(sum(nfree),0) / round(sum(chksize),0)*100 FROM sysdbstab d, syschunks c WHERE ((d.dbsnum = c.dbsnum) AND (is_blobchunk=1)

SELECT name, round(sum(chksize),0), round(sum(chksize),0) - sum(nfree),
sum(nfree), round(sum(nfree),0) / round(sum(chksize),0)*100
FROM sysdbstab d, syschunks c
WHERE ((d.dbsnum = c.dbsnum) AND (prtpage=0) )

or is this the right one?