select c.tabschema, c.tabname
, sum (
case 
 when c.typename='DECIMAL' then int(c.length/2)+1
 when c.typename like 'LONG%' then 24
 when c.typename='VARCHAR' then c.length+4
 when c.typename='GRAPHIC' then c.length*2
 when c.typename='VARGRAPHIC' then c.length*2+4
 when c.typename like '%LOB' then
  case c.inline_length
   when 0 then 
    case
     when c.length<=1024 then 72
     when c.length<=8192 then 96
     when c.length<=65536 then 120
     when c.length<=524000 then 144
     when c.length<=4190000 then 168
     when c.length<=134000000 then 200
     when c.length<=536000000 then 224
     when c.length<=1070000000 then 256
     when c.length<=1470000000 then 280
     when c.length<=2147483647 then 316
    end
   else c.inline_length+4
  end 
 else c.length
end
+ case c.nulls when 'Y' then 1 else 0 end 
) as rowlenght
from syscat.columns c
join syscat.tables t on c.tabschema=t.tabschema and c.tabname=t.tabname
where t.type in ('T', 'S')
group by c.tabschema, c.tabname