저희회사에서 사용하고 있는 query입니다...

스키마에 속해있는 테이블별에 대한 length, card, 크기를 보여주는 query 입니다.

select substr(a.tabschema,1,3) TABSCHEMA,
       substr(a.tabname,1,15) TABNAME,
       decimal(a.row_length,5,0) LENGTH,
       decimal(b.card,10,0) CARD,
       decimal((decimal((a.row_length*b.card),15,0)/1024/1024),15,0) SIZE
from ( select substr(tabschema,1,3) as tabschema,
              substr(tabname,1,15) as tabname ,
              sum(length+ case typename when 'VARCHAR' then 2 else 0 end
                 + case nulls when 'Y' then 1 else 0 end) as row_length
       from syscat.columns
       where tabschema in ('ACE','BSS','CLA','COM','CSM','CTF','CTK','CTL','LOW')
       and tabname not like 'V_%'
       group by tabschema,
                tabname
     ) a,
       syscat.tables b
where a.tabname = b.tabname
  and a.tabschema = b.tabschema
order by a.tabschema,
         a.tabname
;

답변 감사드립니다..^^;;