【无标题】

db2 查询数据库下所有schema 下表的占用空间大小

select 'xspace:',TABSCHEMA||TABNAME,cast((DATA_OBJECT_P_SIZE + INDEX_OBJECT_P_SIZE + LOB_OBJECT_P_SIZE)/1024.00 as decimal(13,2)) AS TOTAL_P_SIZE 
FROM SYSIBMADM.ADMINTABINFO where TABSCHEMA not in 'SYSTOOLS' order by TOTAL_P_SIZE desc