The results in the following query do not reflect the same record length displayed in Control Center, Estimate Statistics panel in UDB AIX. Why? How could I build a query that generates record length for every table?
select tabname,sum(length)
from syscat.columns
where tabschema = '<schema-name>'
group by tabname
select tabname,sum(length)
from syscat.columns
where tabschema = '<schema-name>'
group by tabname