DB2 查看表占用空间大小

1、查看数据库页大小

db2 get db cfg

2、收集表状态信息

db2 runstats on table schema.table_name

3、查询数据表占用页的数量

select tabname, npages from syscat.tables where tabname = ‘table_name’

4、计算表占用磁盘空间大小

表占用磁盘空间大小 = 数据页大小 * 页数量

查看表占磁盘空间大小：select tabname, npages16384/(10241024) from syscat.tables where tabname = ‘XXXXXX’

db2 v9以上查看表占磁盘逻辑空间大小：select sum(x.DATA_OBJECT_P_SIZE+x.INDEX_OBJECT_P_SIZE+x.LOB_OBJECT_P_SIZE+x.LONG_OBJECT_P_SIZE+x.XML_OBJECT_P_SIZE) from SYSIBMADM.ADMINTABINFO x where TABNAME=‘XXXXXXX’;

select TABNAME,sum(x.DATA_OBJECT_P_SIZE+x.INDEX_OBJECT_P_SIZE+x.LOB_OBJECT_P_SIZE+x.LONG_OBJECT_P_SIZE+x.XML_OBJECT_P_SIZE) from SYSIBMADM.ADMINTABINFO x group by TABNAME;

db2 v9以上查看数据库占用空间大小：db2 “call SYSPROC.GET_DBSIZE_INFO(?,?,?,10)”