# Посмотреть db2 installation_path
/usr/local/bin/db2ls

# Получить полный список instance'ов (вероятно единственный db2inst1)
for inst_path in $(/usr/local/bin/db2ls|tail -n +4|awk '{print $1;}'); do ${inst_path}/instance/db2ilist; done

# Для каждого instance'а (на примере db2inst1, подставьте ниже в первой строке свой/свои)
su - db2inst1
. sqllib/db2profile
db2pd -alldbs -tablespaces
df -gP $(db2pd -alldbs -tablespaces|grep -p "Containers:"|tail -n +3|awk '{print $9}')
df -g
db2level
db2licm -l 

with t1 as (
  SELECT tabschema, tabname
        ,SUM(DATA_OBJECT_P_SIZE + INDEX_OBJECT_P_SIZE + LONG_OBJECT_P_SIZE + LOB_OBJECT_P_SIZE + XML_OBJECT_P_SIZE) as full_p_size
        ,SUM(INDEX_OBJECT_P_SIZE) as IDX_P_SIZE
        ,SUM(LONG_OBJECT_P_SIZE + LOB_OBJECT_P_SIZE) as lob_p_size
        ,SUM(DICTIONARY_SIZE) as DICTIONARY_SIZE
  FROM SYSIBMADM.ADMINTABINFO GROUP BY TABSCHEMA, TABNAME
)
select t1.*
      ,substr(t2.TBSPACE,1, 24) TBSPACE
      ,substr(t2.INDEX_TBSPACE,1, 24) INDEX_TBSPACE
      ,t2.CARD
      ,t2.AVGROWSIZE
      ,t2.COMPRESSION
      ,t2.STATS_TIME
      ,CAST(full_p_size*100./sum(full_p_size) OVER() as DECIMAL(5,2)) as psize_pct
      ,CAST(sum(full_p_size) OVER(order by full_p_size desc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) * 100./sum(full_p_size) OVER() as DECIMAL(5,2)) as full_p_size_pct_sum
from t1 join syscat.tables t2 on (t1.tabschema, t1.tabname)=(t2.tabschema, t2.tabname)
order by full_p_size desc
fetch first 25 rows only
with ur;

db2 connect to <имя вашей базы>
db2 REORGCHK CURRENT STATISTICS ON TABLE tabschema.tabname| tee tabschema.tabname.txt