4K REGULA表空间就是64G大小,没法扩。你现在要做的就是看下哪张表占用较多,用这条语句看:
db2 "select varchar(TABSCHEMA,20) as tabschema,varchar(TABNAME,50) as tabname,SUM(DATA_OBJECT_P_SIZE) as data_obj,SUM(INDEX_OBJECT_P_SIZE) as
index_obj,SUM(LONG_OBJECT_P_SIZE) as long_obj,SUM(LOB_OBJECT_P_SIZE) as xml_obj from sysibmadm.ADMINTABINFO where TABSCHEMA='XXXX' GROUP BY TABSCHEMA,TABNAME with ur"
TABSCHEMA XXXX为实例名,SYSCATSPACE表空间中都是实例创建的表。