DB2 DPF 查看表占用的空间大小？

我根据您的需求，刚刚写了条SQL，您可以去测试下，有问题再交流。

-- 多分区数据库 TOP50 大表物理磁盘空间使用量查询

select
varchar(tabschema,60) as tabschema,
varchar(tabname,60) as tabname,
sum((DATA_OBJECT_P_SIZE+INDEX_OBJECT_P_SIZE+LONG_OBJECT_P_SIZE+LOB_OBJECT_P_SIZE+XML_OBJECT_P_SIZE)/1024/1024) as tabsiz_GB

from sysibmadm.admintabinfo
group by tabschema,tabname
order by tabsiz desc
fetch first 50 rows only

$ db2 "select substr(tbsp_name,1,30) as TBSPNAME,member, TBSP_TOTAL_PAGES, TBSP_USED_PAGES, TBSP_FREE_PAGES from table(MON_GET_TABLESPACE( '',-1))"