db2 查询表空间使用情况

select tablespace_name,                                                  
       sum(float(total_pages*page_size)/(1024*1024*1024)) total ,   -- GB
       sum(float(usable_pages*page_size)/(1024*1024*1024)) usable,  -- GB
       sum(float(used_pages*page_size)/(1024*1024*1024)) used,         -- GB
       sum(float(free_pages*page_size)/(1024*1024*1024)) free_all      -- GB
 from table(snapshot_tbs_cfg('dwtest',-2)) as aa                           
 group by tablespace_name

 

 注: dwtest 为数据库实例名