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('bass_dw',-2)) as aa
group by tablespace_name
DB2查看表空间大小
最新推荐文章于 2023-12-21 17:36:47 发布