回复 1# wangzk0206 SELECT TABSCHEMA, TABNAME,DBPARTITIONNUM, SUM(DATA_OBJECT_P_SIZE), SUM(INDEX_OBJECT_P_SIZE), SUM(LONG_OBJECT_P_SIZE), SUM(LOB_OBJECT_P_SIZE), SUM(XML_OBJECT_P_SIZE) FROM SYSIBMADM.ADMINTABINFO WHERE (TABSCHEMA, TABNAME)=('LIUZIZHUAN','B') group by TABSCHEMA, TABNAME,DBPARTITIONNUM WITH UR ;
并结合SYSCAT.TABLES的表的几个对象(DATA、INDEX、LOB、XML)表空间分配一起来分析。