select 
  SUBSTR(name,  1 ,  40 ) dbspace_name, 
  sum(nfree) free_pg, 
  sum(chksize) size_pg 
from sysdbspaces, syschunks 
where sysdbspaces.dbsnum=syschunks.dbsnum
group by  1 

-----------------------------------------------------
-- List all dbspaces with attributes  (size in KB)
--  ONLY IDS 7.3+ & 9.3+   
--  BUT NOT FOR 10.00+
--
-- V.Shulzhenko  DBA_Tools  2006-12 (2004-03)
-----------------------------------------------------
set isolation to dirty read;
SELECT  substr(d.name, 1 , 18 )             dbspace_name_18
        ,substr(d.is_mirrored, 1 , 2 )      mir
        ,substr(d.is_temp, 1 , 2 )          tmp
        ,substr(d.is_blobspace, 1 , 2 )     bls
        ,substr(d.is_sbspace, 1 , 2 )       sbs
        ,case when bpagesize= 0                   -- not Blobspace
              then ' '
              else substr(round(bpagesize/ 1024 , 0 ), 1 , 3 )||'K'
         end                            bpage
        ,substr(d.nchunks, 1 , 3 )          chk
        ,substr(round(sum(chksize*v.sh_pagesize/ 1024 )), 1 , 9 )     size_kb
        ,substr(round(sum(chksize*v.sh_pagesize/ 1024 )-
                      sum(nfree/ 1024 *(case when is_blobspace= 0  then v.sh_pagesize
                                           else bpagesize end))
                     ), 1 , 9 )                                     used_kb
        ,substr(round(sum(nfree/ 1024 * (case when is_blobspace= 0  then v.sh_pagesize
              else bpagesize end))), 1 , 9 )                        free_kb
FROM sysdbspaces d, syschunks c, sysdbstab t,sysshmvals v
WHERE d.dbsnum = c.dbsnum
      AND c.dbsnum = t.dbsnum
group by  1 , 2 , 3 , 4 , 5 , 6 , 7 
order by  1