RE: Determine Size of Database

McCabe-Reed, Barbara SIK wrote > My objective is to get the pages used per each dbspace. Is that feasible? Thanx. This is a slighly modified script from Lester Knutsen - dbaccess sysmaster 2>/dev/null <<! select d.dbsnum, name dbspace, -- name truncated to fit on one line sum(chksize) Pages_size, -- sum of all chuncks size pages sum(chksize) - sum(nfree) Pages_used, sum(nfree) Pages_free, -- sum of all chunks free pages round ((sum(nfree)) / (sum(chksize)) * 100, 2) pc_free from sysmaster:sysdbspaces d, sysmaster:syschunks c where d.dbsnum = c.dbsnum and d.is_blobspace = 0 group by 1, 2 order by 1 into temp A; select dbspace[1,8], pages_size, pages_used, pages_free, pc_free from A; drop table A;! It DOES NOT show blobspaces. You need a separate script for those. See recent threads. ________________________________________________________________________ This email has been scanned for all known viruses by the MessageLabs Email Security System. ________________________________________________________________________ sending to informix-list