1关联这三张表就有了sysibmadm.CONTAINER_UTILIZATIONsyscat.tablessyscat.tablespaces 2.例如select a.tabname,b.CONTAINER_NAME from syscat.tables a ,sysibmadm.CONTAINER_UTILIZATION b ,syscat.tablespaces c where a.TBSPACEID=c.TBSPACEI...
显示全部1关联这三张表就有了
sysibmadm.CONTAINER_UTILIZATION
syscat.tables
syscat.tablespaces
2.例如
select a.tabname,b.CONTAINER_NAME from syscat.tables a ,sysibmadm.CONTAINER_UTILIZATION b ,syscat.tablespaces c where a.TBSPACEID=c.TBSPACEID and c.TBSPACEID=b.TBSP_ID
3.具体需要哪些字段自己查看表结构
收起